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

Change Data Source but page reports and visualizations linked to new data

How do I change the query/data source on powerbi so all the end user reports stay the same? The fields are all there from the original, but it has a larger sample of data with a couple of extra fields

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Change Data Source but page reports and visualizations linked to new data

@lowei ,

 

So query means power query, right? If it is, I'm afraid the power query steps should be recreated after data source changing.

 

Community Support Team _ Jimmy Tao

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

4 REPLIES 4
Community Support Team
Community Support Team

Re: Change Data Source but page reports and visualizations linked to new data

@lowei ,

 

Click Edit Queries-> Data source settings and select the datasource, then click edit credentials.

Capture.PNG  

 

Community Support Team _ Jimmy Tao

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

Highlighted
lowei Frequent Visitor
Frequent Visitor

Re: Change Data Source but page reports and visualizations linked to new data

Thanks, this almost gets me there!

 

I made a query that combines multiple files, but when I use this, its only allowing me to change the source, so I can't pick the created query. How would I go about doing that?

Community Support Team
Community Support Team

Re: Change Data Source but page reports and visualizations linked to new data

@lowei ,

 

So query means power query, right? If it is, I'm afraid the power query steps should be recreated after data source changing.

 

Community Support Team _ Jimmy Tao

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

Community Support Team
Community Support Team

Re: Change Data Source but page reports and visualizations linked to new data

@lowei ,

 

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

 

Regards,

Jimmy Tao