Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Power BI community,
We have a report published to online service (Pro license) which uses the incremental refresh for almost tow years now, we now think the incremental refresh is not the suitable way for storing historical data specially when we want to update the report. then we changed the policy to storing data frequently in azure blob storage and link the report to it. however we want to migrate the data which is saved in the report by the incremental refresh, that means we want to export it and append it to the files in the new blob storage.
We tried the export to excel and we select the fields from the pivot table manually than use a C# application to get the data as a json and append it to the json file in the blob storage, but this looks like a hurdle because we have to select hundreds of fields in many tables manually and handling the excel became hard and too slow.
We tried different libraries to select pivot table fields using code but that didn't work since none of them could even detect the pivot table.
Is there any other suggestion on how to export the data in a structured format in such a way that we can easily handle?
We appreciate your help!
don't know if could work in your scenarios... I've 2 ideas you could try:
- Datasets - Execute Queries - REST API (Power BI Power BI REST APIs) | Microsoft Learn
pay attention to limitations