Power Query greyed out

[P-Lag]

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 does not exist. 

Best regards, Pauline

[Jai-Rathinavel]

@P-Lag Try connecting to Analysis Server model using Import mode like below under Get data

Did I answer your question ? Please mark this post as a solution.

Thanks,

Jai

[P-Lag]

Yes, in live mode 🙂 

[v-junyant-msft]

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]

Hi, 

It is not possible to import the data source. 

[v-junyant-msft]

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.

[lbendlin]

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

[P-Lag]

Hi, 

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

[lbendlin · Accepted solution]

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

[Jai-Rathinavel]

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

Thanks,

Jai

[lbendlin]

Are you connecting to a SSAS Tabular model in live mode?