How to point the existing report to a different Query ?

[aerosanth16]

Dear Power BI experts,

I have an existing power BI report with multiple pages.

All the visuals in the exisitng report is built using Fields in refers to Query A.

Now i want to replace all the visuals to refer to Query B.

I have all the Fields required to produce the visuals in Query B also, Names are also exactly name.

Where & How can I tell Power BI that Refer to Query B instead in Query A for ALL the visuals in ALL the pages this Report, in one go ?

Regards & Thanks,

Santhosh M

[akul · Accepted solution]

What you want to achieve is not supported by PowerBI. You cannot change the table/query from which the visual picks up the field to show data programatically. You need to manually change all the fields in the visuals from A to B.
However, you can append the two queries i.e. A and B together into say C. (I presume both A and B queries have the same table structure as you just want to replace the table name in the visuals to get the data from other query) Before appending, just add a column in both the queries having the query name. So now, query C has all the data of both A and B and also has the info about which data belongs to which query i.e. the new column you added.

Now you would have to change all the visuals to use fields from C and then you can just put a filter or a slicer visual to change between A and B using the query name field.

Hope I understood your problem correctly and was able to answer correctly as well. If this resolved your issue, mark this as an accepted solution!

[Anonymous]

@aerosanth16 ,

You can check this - https://www.kasperonbi.com/how-to-point-existing-reports-to-a-new-dataset-in-power-bi-even-from-aas/ if this helps you.

Appreciate your kudos!! Please mark my post as solution if this suits your requirement.