Forum Discussion
Solved
Incremental Refresh
This dataset includes a dynamic data source. Since dynamic data sources aren't refreshed in the Power BI service, this dataset won't be refreshed I am getting this error how can I fix these so I ...
Download the cold data into CSV files that you store on OneDrive. Append them in Power Query with your warm and hot partitions.
- letsearchText = "2024-09-06",csvContent = Web.Contents(url, [Headers=[Authorization="vToken " & Login2()],RelativePath = searchText] )incsvContent
Thank you for your response, and is there a way to speed up the query, I have 10 Million rows of data most of them are cold data (Historic from a year ago) and it doesn't change anymore the only one that changes is from 3 months prior current date and after that it doesn´t change, every time I update my query fetches all 10 million rows and takes hours, is there a more efficient way to aproach this..
Thanks for your help
Download the cold data into CSV files that you store on OneDrive. Append them in Power Query with your warm and hot partitions.