Forum Discussion
Historic data (last 4 days data), dataflow vs dataset ?
Can you just close this thread by accepting it, if it is solved
Thanks
So my data is 3 million rows, takes forever to load in the power bi desktop. (import mode)
is it going to be the same refresh time when I upload it to service (import mode)
Community ChampionAnonymous
Not sure about 3 million rows will take for ever! besides you are gonna have to do some ETL to your data, and build a dataset. You are gonna keep only the data you need for your reports. Direct Query mode is another way to bring your data.
Refreshing the data in the service: there are other techinques to make the refresh takes less time, like using paramaters or incremental refresh.
Thank you so much, one last question, is incremental refresh possible only with import mode ? I am having a timeout issue with dataflow eventhough i set command timeout to be 60 minutes but i opened another thread for it
- aj1973
No both Import and DQ but maybe with some limitations, here is a link to follow
https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
https://docs.microsoft.com/en-us/power-bi/guidance/power-query-folding
Where is the thread to your other issue?
The dataflow topic is here
https://community.powerbi.com/t5/Service/dataflow-operation-timed-out/m-p/1798401#M126631