Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Eashas
Regular Visitor

Power query is not active

My Lion:
Hey everyone. Help me guys i have some problem when try to open power query editor. First i connected to Sql Database than try to open power query editor to create measured column for date range. But when i try to open Power query Tab i can only modify my connection to database but can not open power query editor. How i can solve my problem ?
2 REPLIES 2
v-frfei-msft
Community Support
Community Support

Hi @Eashas,

 

Based on my test, I cannot reproduce your issue, as I can open the Edit Queries in both import and direct query modes when connecting to SQL server database.  Do you connect to SSAS data source? If you connect to SSAS using connect live, then it is not possible to open query editor and this behavior is by design.

 

1.jpg

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Hi @Eashas,

 

Is that helpful? If so , kindly mark the answer as a solution to close the case, thanks in advance.

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.