If you want to use a Power BI for your data visualization, you will be faced with the following question, when your data source is an SQL Server database : do you want to import or use a direct query as a data connectivity mode?