Forum Discussion
DirectQuery for Power BI datasets and Azure Analysis Services - unable to connect other source
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
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 😞
7 Replies
In the lower-right of Power BI Desktop, next to the Live Connection label is a link to convert the model to DirectQuery:
Hi Jeff,
I've checked but, I don't have this kind of link in the lower right corner.
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 😞
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
