Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 😞
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
Hi Eric,
Close the app after you enable the feature. It needs a restart.
Regards
I did... ☹️
I am using a free PowerBI account... Would that make a difference???
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 😞
Solved. I didn't have the feature enabled.
Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.