Forum Discussion
Is delayed data load possible (or is my concern for performance unwarranted)?
wittr9876,
You can use DirectQuery mode to connect to SQL Azure database in Power BI Desktop. With this mode, no data is imported into the Power BI store. Instead, upon building a visual within Power BI Desktop, queries will be sent to the underlying data source to retrieve the necessary data. The time then taken to refresh the visual will depend on the performance of the underlying data source.
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
Regards,
Lydia
wittr9876,
You can use DirectQuery mode to connect to SQL Azure database in Power BI Desktop. With this mode, no data is imported into the Power BI store. Instead, upon building a visual within Power BI Desktop, queries will be sent to the underlying data source to retrieve the necessary data. The time then taken to refresh the visual will depend on the performance of the underlying data source.
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery
https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about
Regards,
Lydia