Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Update data source (OData connection string) for PBIX report on PBI report server

We have a PBIX template which is pulling data from OData source. Now this report needs to get deployed to each customer's folder separately on Power BI farm. Each copy needs to point to respective customer's OData service.

We have automation where we use SSRS APIs to upload the report to farm and then update data source on report. (NOTE: This works fine for PBIXs which are not OData sourced.)


However we notice that post upload, data source OData connection string property is disabled by MSFT. This tells us that MSFT do not allow this but still we gave a try to update the connection string and it returned 400 bad request response as expected.


Just FYI we are using following API to update data source on PBIX:

Also we tried looking at DataModelDataSource table on RS DB, but again the ConnectionString value is encrypted here for security concern:



Next we also tried to update this PBIX file before uploading it to farm. Coverting PBIX to ZIP, extracting files and then updating DataMashup file (replacing OData connection). And then again ZIP the folder contents and rename extension to PBIX but that did not work. PBIX report gets corrupted.
Also observed that even if you open and close any file (notepad++) without any change, still the report gets corrupted. Found following link which worked for them but did not for me:

Now we are left with only one option where we will have to ask each customer to manully do this. That includes download this report, open report in PBI Desktop, update connection string and then reupload it to farm.

Let me know if anyone have any workaround for this issue.



Community Support
Community Support

Hi @SagarSalvi ,


Maybe the following post will helpful. 


Best Regards

Community Support Team _ chenwu zhu

Hey @v-chenwuz-msft 


Thanks for looking at my post. Issue I mentioned is very specific to PBIX with data source type OData.
For other types of data source we are not seeing this issue at all. MSFT has only disabled connection string input for OData type sources (first screenshot in my post above). 

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.