Forum Discussion
Performance/Resource-Usage "best practice" question on how PowerBi/GetData load data
When using import mode to connect to Azure SQL database in Power BI Desktop, all data of large tables will be loaded into Power BI Desktop, large amount of transform steps in query editor are processed based on all the data of large tables, which will eat memory of your machine and cause performance issues at the time you apply changes to data model.
In your scenario, it is recommended to import required columns and rows with a SQL query and then make transformations in Power BI Desktop, for more tips about Power BI performance, please review this article: https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance.
Regards,
Lydia
When using import mode to connect to Azure SQL database in Power BI Desktop, all data of large tables will be loaded into Power BI Desktop, large amount of transform steps in query editor are processed based on all the data of large tables, which will eat memory of your machine and cause performance issues at the time you apply changes to data model.
In your scenario, it is recommended to import required columns and rows with a SQL query and then make transformations in Power BI Desktop, for more tips about Power BI performance, please review this article: https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance.
Regards,
Lydia