Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
raulcruzv
Frequent Visitor

Datasource change environment

In order to redirect a report wich was deployed into Power BI Online from QA to PROD environment, Is it really necesary to do that modification in a new PIB desktop file? Isn't it possible to do that from the service itself?

5 REPLIES 5
_sfrost
Solution Specialist
Solution Specialist

@raulcruzv 

AFAIK, you can achieve this with the following REST API. However, it supports only limited number of sources and it has few restrictions. For more info, I would suggest you to refer to the below doc:

Datasets - Update Datasources In Group (Power BI Power BI REST APIs) | Microsoft Docs

 

Did I answer your questions? Give a thumbs up and accept this post as solution!

Anonymous
Not applicable

You can go to Query and "Advanced Editor" and change it manually.

GilbertQ
Super User
Super User

Hi @raulcruzv

 

When you mention "Is it really necesary to do that modification in a new PIB desktop file", what do you mean?

 

Is it for a link for users, or Dashboard tiles linking to the report?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

What I'd like to do is having an option where we are able to modify the datasource without the need of publishing the *.pbix file again.

With "datasource" I mean having the possibility to change from ServerA to ServerB (e.g. SQL Server QA to SQL Server PROD)

@raulcruzv

 

It's not supported to edit the data source on Power BI Service. If you want to change the server name of data source, you have to edit in .pbix file or create a new one and publish again.

 

Regards,

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors