Forum Discussion
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 does not exist.
Best regards, Pauline
You seem to be using an old version of Power BI Desktop and/or you didn't enable the feature in the options.
10 Replies
Are you connecting to a SSAS Tabular model in live mode?
Yes, in live mode 🙂
Add another data source so your live connection is forced into mixed mode (direct query with local model).
Hi,
It's not possible to add another data source? Best regards, Pauline
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.Hi,
It is not possible to import the data source.
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
