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
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
- aj1973
Can you just close this thread by accepting it, if it is solved
Thanks