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.
I have a dataflow with several queries from one DB and it works fine.
I added another query from the same DB and I simply can't make it work (i.e. the preview displays correct data, but any refresh fails). In the meantime I tried copying the query into a new dataflow in order to be sure it's about it and it is.
My advanced query is as follows. I created it by copying it from PowerBI desktop - it works there. Initially I created it in SQL Server Management Studio (mdx) and it shows the correct results there:
Solved! Go to Solution.
Please note that, from the article , we know that the Azure analysis Services instead of SQL Server Analysis Services connector is supported in dataflow. That's should be reason why it doesn't work.
While your demand is a good idea, you can post your new idea in Idea Forum , to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Please note that, from the article , we know that the Azure analysis Services instead of SQL Server Analysis Services connector is supported in dataflow. That's should be reason why it doesn't work.
While your demand is a good idea, you can post your new idea in Idea Forum , to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
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.