cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Cquatre02
Frequent Visitor

Change Datasets for online raport

Hello everyone,

I made a report with a Power bi dataset directly on the web and I'm looking to see if we can change the dataset. For example, going from a test dataset to a real dataset.

I remember I was successful a few months ago, but I can't find the option in settings anymore, any idea?

 

I tried to delete the dataset and indeed I have a message which indicates to me: "There is no dataset associated with this report. Please open the settings pane of the report and pick a dataset to bind the report."

 

But in the parameters I cannot find how to do it :

 

 

Cquatre02_0-1617719175908.png

 

 

1 ACCEPTED SOLUTION
v-deddai1-msft
Community Support
Community Support

Hi @Cquatre02 ,

 

You can also try to use rebind report api :https://docs.microsoft.com/en-us/rest/api/power-bi/reports/rebindreportingroup

 

Here is a good sample for your reference : https://binary-lies-blog.herokuapp.com/rebind-powerbi-reports/

 

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

 

Best Regards,

Dedmon Dai

View solution in original post

7 REPLIES 7
v-deddai1-msft
Community Support
Community Support

Hi @Cquatre02 ,

 

You can also try to use rebind report api :https://docs.microsoft.com/en-us/rest/api/power-bi/reports/rebindreportingroup

 

Here is a good sample for your reference : https://binary-lies-blog.herokuapp.com/rebind-powerbi-reports/

 

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

 

Best Regards,

Dedmon Dai

View solution in original post

v-deddai1-msft
Community Support
Community Support

Hi @Cquatre02 ,

 

There is no approach to change dataset for the report directly in power bi service. You need to download the pbix file and do it in power bi desktop. As mentioned by collinq,  go to File - Options and Settings - Data Source Settings and then Change Data Source.  republish it and replace the existing report. 

 

Here is document for your reference: 

 

https://eriksvensen.wordpress.com/2018/09/19/powerbi-switching-a-report-from-one-powerbi-dataset-to-...

 

https://www.kasperonbi.com/how-to-point-existing-reports-to-a-new-dataset-in-power-bi-even-from-aas/

 

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

 

Best Regards,

Dedmon Dai

collinq
Super User II
Super User II

Hi @Cquatre02 ,

 

The easiest way (in my mind) to change the data source is to open the Desktop file, go to File - Options and Settings - Data Source Settings and then Change Data Source.  I am not sure where in the Service you can just modify the DataSource.  If you are talking about the Gateway, you can change the DataSource in the Gateway Connection settings.




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

Proud to be a Datanaut!
Private message me for consulting or training needs.




Hi Collinq,

Thank you very much for your answer, indeed it is the simplest solution.

 

In fact, the situation is simple in my company, we create power bi datasets that we publish on workspaces, our end users produce reports on the web by connecting to these datasets (they do not have the desktop).

 

However, I wanted to know what to do in the event that we change a dataset from a workspace A -> B

Hi @Cquatre02 ,

 

I guess that I am not quite positive what you mean.  If you "move" a dataset from one workspace to another, you are publishing the file to the new workspace and therefore the dataset is in the "new" workspace.




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

Proud to be a Datanaut!
Private message me for consulting or training needs.




Thanks a lot for your answer,

 

I made a small diagram,

Cquatre02_0-1617890444242.png

 

I made the "report 2" based on the "Dataset test" directly on the web (without using the desktop). I change my dataset from workspace A -> B,

Power bi told me that when i want to open "Report 2":

Cquatre02_1-1617890629305.png

 

But I can't find this option in the settings, But maybe it's just not possible now 😕

HI @Cquatre02 ,

 

Thank you for the diagram - that was helpful.  But, you are right that at the moment the report can't be just "repointed".  You will have to bring the report down and re-point it in the desktop to Workspace B dataset in the file.  And then you can publish it back to Workspace C.




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

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors
Top Kudoed Authors