Forum Discussion
Import or Directy query with about a billion data
I have a table in Azure Datawarehouse with a billion records，the table structure is very simple just include two columns: id int text nvarchar(512) My requirement is not very complicated , just s...
1. Direct query may be faster, but has some limitation. Even with a billion records you should be able to use the Import method. However, as stated there is a limitation on how much data can be imported through the import method.
2. Once you publish the Pbix file to Power BI Service you can set up a gateway and schedule an automatic refresh for a time when no one is on the server.
3. No. Direct query will not create new connections for each user of the report. That is all done on the back end. They will merely be playing with the front end visuals.
4. I would refer to this article in the Power BI Desktop tutorials to make your decision: https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery