Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Where is Power Query in Power Bi Desktop App?

We have been using Power Bi desktop app since it was determined that it has as many features as the standard windows application. I'm looking for a solution to sort columns in a Matrix and i see a lo...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi Anonymous ,

     

    If you use connect live, there's no query defined, and the entire external model is shown in the field list.

    So edit Query is not available in connect live mode.

    You can only contact the data source administrator to modify the data model.

     

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

VijayP's avatar
VijayP
Community Champion
6 years ago

Anonymous
if you are using Dec 2019 or later version in the home tab , you will get one option "Transform" under that you need to select Transform Data to get into Power Query Editor

If you are using older version then you need to select "Edit Queries" and you will be able to go to Power Query EditorPo

Screen Shots atttached

 

Instead of using "Get Data" Option , use "New Source" option in Power Query to have better ETL Options. 

Under Power Query Editor -> Home -> New Source => Select Database ''

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I only have data source settings under Transform Data.

    I've read a bit more and am starting to think it's because we're connecting live to the SSAS cube. 

    Could that be the problem?

    • V-lianl-msft's avatar
      V-lianl-msft
      Community Support
      6 years ago

      Hi Anonymous ,

       

      If you use connect live, there's no query defined, and the entire external model is shown in the field list.

      So edit Query is not available in connect live mode.

      You can only contact the data source administrator to modify the data model.

       

      Best Regards,
      Liang
      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 was able to add a dimension to the cube that allowed me to combine a couple other dimensions and also affect the column sort order in Power Bi. 

        Thanks for confirming what i was thinking might be the problem.

    • az38's avatar
      az38
      Community Champion
      6 years ago

      Anonymous 

      Yes, its correct, Edit Query Mode is not available in Live Connection