Forum Discussion

P-Lag's avatar
P-Lag
Helper I
1 year ago
Solved

Power Query greyed out

Hi,  I will create a Power BI report, with SQL (tabular model) as data source. I can't use Power Query or create new tables. Is it possible to access those features anyway?      This view d...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago

    You seem to be using an old version of Power BI Desktop and/or you didn't enable the feature in the options.

P-Lag's avatar
P-Lag
Helper I
1 year ago

Yes, in live mode 🙂 

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

    Add another data source so your live connection is forced into mixed mode (direct query with local model).

    • P-Lag's avatar
      P-Lag
      Helper I
      1 year ago

      Hi, 

      It's not possible to add another data source? Best regards, Pauline  

       

       

       

      • Jai-Rathinavel's avatar
        Jai-Rathinavel
        Super User
        1 year ago

        P-Lag just open a new Power BI file and select Get data -> Analysis Services.

         

        Thanks,

        Jai

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi P-Lag ,

    You cannot use Power Query when the data connection mode is Live connection. This is by design. Power Query can only use under Import, DirectQuery and Mixed mode.
    And the table view can only exist when the data connection mode is Import mode


    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • P-Lag's avatar
      P-Lag
      Helper I
      1 year ago

      Hi, 

       

      It is not possible to import the data source. 

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Hi P-Lag ,

        After testing, it is possible to use Import mode when connecting to a normal SSAS Tabular model, and it is also possible to add other data sources and use Power Query.
        However, according to the screenshots you provided, it seems that your SSAS Tabular model comes from fabric or Power BI service. In my test, this is the only case where your problem occurs.

        If so, you need to turn on this option in Power BI Desktop's Options and Settings > Options > GLOBAL > Preview features:


        Best Regards,
        Dino Tao
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.