Forum Discussion
Solved
Approach to load huge data
Hi All, Please suggest me to create a dashboard with huge data source of SQL on prime. Records are in Billions Thanks Kamal
Hi kammaru,
Instead of import all data to Power BI, try using DirectQuery mode or a live connection. :smileyhappy:
Reference:
https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/
Regards
You probably need to look at the enterprise gateway and a live connection.