Forum Discussion
Helper IIISQL Server Analysis Services as a Dataflow
Hi Mike282 ,
From the article , we know that the Azure analysis Services instead of SQL Server Analysis Services connector is supported in dataflow.
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.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks v-xicai .
So the answer at the moment is it's not supported for dataflows even with using a Blank Query in Dataflows and copying over the M script.
I've logged the idea and it would be great of others can vote for it.
Resolver IDid you find any luck on this?
I have this requirement as well.
Helper IIINo it just doesn't work unless it's an Azure SSAS. We're basically now questioning whether the data even needs to be in SSAS. Having it in a normal SQL server database will work just as well and you set the cardinality and create the measures in Power BI. Plus you'll be able to link it to a dataflow no problems.
- ChristianDGreat
So basically onprem SSAS cannot be used in dataflow?
I've been researching for awhile and havent found any luck.