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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Slaw
Regular Visitor

Change the dataset for underlying data

Can the data source for a report in Power BI Service be changed?

 

I attempted to publish reports from Power BI, such as for the DEV and PROD environments, with different file names that included 'dev' and 'prod'. However, after publishing, the data source was created with the same name as the report.

 

Is it possible to modify the DEV report to use the PROD data source?

Example:

Power BI pbix file: PROD - App 1.0
Power BI prod dataset: PROD - App 1.0

Power BI pbix file: Dvb - App 1.x (may vary)
Power BI dev dataset: Dev - App 1.0 <-- I would like to use the PROD - App 1.0 dataset.

1 ACCEPTED SOLUTION
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

I think this mya help: https://powerbi.microsoft.com/it-ch/blog/connecting-to-datasets-in-the-power-bi-service-from-desktop....

basically you have two file the dataset file and a pbix report file with a live dataset conection over the service dataset already published, this way you only need to update the dataset pbix and the report one will be already connected to it. 

 

also if you want to change the source target to a diferent dataset with a different name you can do so in the power bi desktop file of the report file in the data source settings under the tranform data queries tab. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




View solution in original post

1 REPLY 1
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

I think this mya help: https://powerbi.microsoft.com/it-ch/blog/connecting-to-datasets-in-the-power-bi-service-from-desktop....

basically you have two file the dataset file and a pbix report file with a live dataset conection over the service dataset already published, this way you only need to update the dataset pbix and the report one will be already connected to it. 

 

also if you want to change the source target to a diferent dataset with a different name you can do so in the power bi desktop file of the report file in the data source settings under the tranform data queries tab. 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors