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. Not...
Need Help
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.

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

    Hi Anonymous ,

    Maybe you can delete the 'Renamed Columns' and 'Added Items' in Applied steps.

    Please refer the simliar case:

    Expression Error.: The key didn't match any rows in the table 

     

    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

      We have reports with a huge number of applied steps , by deleting them , it would be redoing all that we have done previously. I tried to change this in every step that I have applied but still get the same error.