Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric Ideas just got better! New features, better search, and direct team engagement. Learn more

0

Power Bi Desktop May Update - Import data from SSAS ignoring DAX query

Today I updated Power BI Desktop to the latest version and I noticed that importing data from SSAS Tabular using a MDX or DAX query ignores this query completely and sends you to the model browse form. Posted comparison between 2016 May Update and previous versions in Community forum: http://community.powerbi.com/t5/Desktop/Power-Bi-Desktop-May-Update-Import-data-from-SSAS-ignoring-DAX/m-p/41340#M15630
Status: Completed
Comments
nishalit
New Member
This has been resolved. Sorry for the inconvenience.
chass
Impactful Individual
Hello Aaron, I have asked the team to take a look. Thanks, Chuck
AaronVi
New Member
Thank you very much! The workaround is Get Data/Blank Query and type the command: =AnalysisServices.Database("SSAS_SERVER", "Database", [Query="YOUR DAX QUERY"]) It looks like the bug affects only the Get Data/Analysis Services dialog.
abedi
New Member
Same issue here. Unfortunately we are in the process of migrating many of our reports to PowerBI dashboards via cube connection and this bug is putting a stop to our production. A new release with the fix is highly appreciated!
angus_g_jordan
New Member
I am being asked to supply SSAS cubes, pbix files and mdx queries? No way I can send SSAS databases. Can the support teams replicate this using the microsoft test SSAS databases? It doesn't seem that hard to replicate?
Stef_cohen
New Member
This bug stucked my project....please fix it ASAP
micshpar
New Member
Guys, please fix - this just stopped us from developing in PowerBI. Please - fix ASAP Thank you
fbcideas_migusr
New Member
Status changed to: Completed