PowerBI C# Editing source files paths in DataMashup file // Programatically changing datasets

[Anonymous]

Hello,

I want to automate changing source files paths in my report. I want to do this because I will be publishing the same report for many clients, each with different data set.

When I unzip .pbix file I can see that those paths are saved in the Data Mashup file in a readable form. However, when I change them and load .pbix file again I get an error that the report is corrupted.

I notice that there is some sort of header and footer that are not human-readable. I guess there is some kind of checksum there. Any idea what kind of checksum is there, and how can I edit that? 

Alternatively: is there an alternative so I can update dataset programmatically and maybe even upload it to separate Workspace? 

[v-jiascu-msft]

Hi @Anonymous,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

[v-jiascu-msft · Accepted solution]

Hi @Anonymous,

The power-bi-templates could be helpful. I would suggest you try out the Power BI REST API. Upload the pbix reports with power-bi/imports/postimportingroup and then update the data source with datasets/updatedatasourcesingroup.

Best Regards,
Dale