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
8 Comments
- This has been resolved. Sorry for the inconvenience.
- chass
Impactful Individual
Hello Aaron, I have asked the team to take a look. Thanks, Chuck - 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.
- 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!
- 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?
- This bug stucked my project....please fix it ASAP
- Guys, please fix - this just stopped us from developing in PowerBI. Please - fix ASAP Thank you
- Status added:Completed
Recent ideas
executeDaxQueries-like API call with effectiveUserName on SSO-enabled model with Service Principal
Please provide a way for a service principal to execute DAX - with an effective user name - against an SSO-enabled directlake semantic model and get per-user results that respect lakehouse OneLake Se...
