DirectQuery for Power BI datasets and Azure Analysis Services - unable to connect other source

[kta87]

Hello,

  I have the last update of PBI Desktop, that has the new featured "DirectQuery for Power BI datasets and Azure Analysis Services".

  I've created a live connection to SQL Server Analysis Services database model, and I tryied also to connect other sources but isn't working, the "Get Data"  button is unavailable.

 Is this feature works for this kind of connection? 

 My version of PBI is: 2.88.802.0 64-bit (December 2020)

Thank you,

Kta

[EricMamet]

I have a similar problem where it behaves as if the option was not enabled... but I think it is! 🤔

Yet, I don't see any option in that bottom right corner... 

Any idea what I might be missing?

Thanks

[kta87]

Hi Eric,

  Close the app after you enable the feature. It needs a restart.

Regards

[EricMamet]

I did... ☹️

I am using a free PowerBI account... Would that make a difference???

[jeffshieldsdev]

In the lower-right of Power BI Desktop, next to the Live Connection label is a link to convert the model to DirectQuery:

[kta87]

Hi Jeff,

   I've checked but, I don't have this kind of link in the lower right corner.

[jeffshieldsdev · Accepted solution]

Oh, you said Analysis Services, your screenshot shows Power BI Dataset.

I also see the link when connected to a dataset too though:

There's also this button the ribbon:

You've restarted Power BI Desktop after enabling the preview feature?

That's the version number I have installed: Version: 2.88.802.0 64-bit (December 2020)

I always use the single installer version: https://aka.ms/pbiSingleInstaller 

Not sure what else could be at play 😞

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...

[kta87]

Solved. I didn't have the feature enabled.

Thank you