cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
wieke2
New Member

Change data source in PowerBI service

Hi! I created a report in PowerBI service (on a dataset that I published from Desktop). Now I want the same report on different data sources.

 

I tried two ways, but both are not possible:

1. Change datasource in Desktop and publish it again -> Report in PowerBI service does not connect with new sources

2. Wanted to download the Report in PowerBI service as pbix -> Not possible because report has not been created in Desktop

 

Is there any way I can do this? I'm afraid I have to rebuild my whole dashboard....

1 ACCEPTED SOLUTION
ibarrau
Super User
Super User

Hi. I'm sorry but you can't. You should always start developing from Desktop in order to keep backups, versioning and modification possibilities.

Sadly you need to connect a pbix file to the dataset and rebuild the report you have created online. Once you have the file connected you can change the sources if you have different environments or things like that. Even copy paste from pbix to pbix 😛

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

1 REPLY 1
ibarrau
Super User
Super User

Hi. I'm sorry but you can't. You should always start developing from Desktop in order to keep backups, versioning and modification possibilities.

Sadly you need to connect a pbix file to the dataset and rebuild the report you have created online. Once you have the file connected you can change the sources if you have different environments or things like that. Even copy paste from pbix to pbix 😛

I hope that helps,


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors