Forum Discussion
Eashas
8 years agoRegular 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 ?
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
- v-frfei-msftCommunity 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.
Regards,
Frank
- v-frfei-msftCommunity Support
Hi Eashas,
Is that helpful? If so , kindly mark the answer as a solution to close the case, thanks in advance.
Regards,
Frank