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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.