cancel
Showing results for 
Search instead for 
Did you mean: 
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 Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors
Top Kudoed Authors