Forum Discussion
SQL 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.
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.
Hi Mike282 did you ever figure out a workaround for this issue?
Unfortunately no. It's an available feature. They support Azure SSAS but not anything on premise. You'll see in this post I posted a link to a feature suggestion I made for this. If you can vote on it, I'm hoping if enough people kick up a fuss they'll finally do it.
Understand why they'd do it because with their cloud SSAS they'd make money on it.
My workaround (which really only works if your data refresh cycle is infrequent) is to pull the on-prem AS data into an XL file stored on OneDrive and have your Dataflow use that as it's source. It's a pain, because it's a two-step refresh. If Dataflows could prompt an XL-online file to refresh and wait for it, then refresh against it, that would be handy. Maybe could do that with Power Automate, but I don't have the patience to figure it out.