Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to change source from one query to another query

Hi All,

I have created a Power BI report using SAP Business Warehouse and connected to a BEx query Z_Qry_F1 . Now I would like to repoint the same Power BI report to a different query Z_Qry_F2.

Note :Both the strcutures are same and there is no difference between both the queries.

Can someone please let me know how to do this in Power BI desktop.

 

Thanks

Poojitha

Need Help

5 Replies

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

    You can try these two ways when opening Power Query Editor in power bi desktop:

    1. Changing data source directly in Advanced Editor
    2. Using the 'Navigation' in Applied steps on the right of query editor

     

    Best Regards,
    Yingjie Li

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I tried to do it from the applied steps and I get the below error.

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago
    Use the Advanced Editor in Power Query. Or depending on exactly what you want to do, sometimes you can just use the gear icon next to the Source step.