Forum Discussion

Eashas's avatar
Eashas
Regular Visitor
8 years ago

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

  • v-frfei-msft's avatar
    v-frfei-msft
    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.

     

     

    Regards,

    Frank

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support

      Hi Eashas,

       

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

       

      Regards,

      Frank