cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

Programatically change the Data Source connection of .PBIX file

Hi,

 

We have requirement to replicate same report to multiple client, only we need to change the data source. Is there any way i can programtically change the data source of .pbix file without open the file and automatically publish to Power Bi report server?

 

 

 

Thanks

 

5 REPLIES 5
Highlighted
Microsoft
Microsoft

Re: Programatically change the Data Source connection of .PBIX file

Hi @Miruthan,

 

Here is a similar thread in which a possible solution to programtically change the data source of .pbix file without open the file is mentioned. Could you go to check if it helps in your scenario?

 

As to automatically publish to Power Bi report server, I haven't seen a possible solution currently. Smiley Happy

 

Regards

Highlighted
Advocate II
Advocate II

Re: Programatically change the Data Source connection of .PBIX file

hi @v-ljerr-msft I dont think the solution will help me, I am connecting SSAS multi dimensional cube,. Is there any way using C# or powershell i can update the connection string.

Highlighted
Microsoft
Microsoft

Re: Programatically change the Data Source connection of .PBIX file

Hi @Miruthan,

 

As far as I I know, there're no such ways using  C# or powershell to update the connection string for a pbix file currently. Smiley Happy

 

Regards

Highlighted
Advocate I
Advocate I

Re: Programatically change the Data Source connection of .PBIX file

Hi Miruthan,

 

Did you able to achieve this? We have exactly same need except we want to change SQL DB and not SSAS.

 

Please let me know.

 

Cheers,

Dhawal

Highlighted
Advocate II
Advocate II

Re: Programatically change the Data Source connection of .PBIX file

Hi @dhawal,

 

No, We are not able to achieve, but we need to find the workaroud. Please share your thoughts if you have some.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors