cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SagarSalvi
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.

SagarSalvi_1-1665084423914.png


Just FYI we are using following API to update data source on PBIX:
https://app.swaggerhub.com/apis-docs/microsoft-rs/pbirs/2.0#/PowerBIReports/UpdatePowerBIReportDataS...

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

SagarSalvi_2-1665084631061.png

 


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:

https://community.powerbi.com/t5/Desktop/Modifying-the-Layout-file-that-is-embedded-in-a-pbix-file/m...

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.

 

 

2 REPLIES 2
v-chenwuz-msft
Community Support
Community Support

Hi @SagarSalvi ,

 

Maybe the following post will helpful.

https://community.powerbi.com/t5/Power-Query/Data-Source-Changing/td-p/430529 

 

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

Announcements
Carousel_PBI_Wave1

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!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.