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.

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.