cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
blaz11 Frequent Visitor
Frequent Visitor

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

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? 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

Hi @blaz11,

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

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

Hi @blaz11,

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community Support Team
Community Support Team

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

Hi @blaz11,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.