Forum Discussion

SELECTDBA's avatar
SELECTDBA
Advocate I
6 years ago

SSAS Analysis source through blank query in a Dataflow

Hello all,   We're having difficulities adding an on-prem SSAS analysis service connection through a blank query on a Dataflow.  I've added the correct Power Query:   let Source = AnalysisSe...
Dataflow
Need Help
GilbertQ's avatar
GilbertQ
Super User
6 years ago
Hi there

What if you try and create the query in Power BI Desktop first?

Also remember that when setting up the Gateway the Domain\UserAccount has to be an Admin on your SSAS Server for the queries to work.
SELECTDBA's avatar
SELECTDBA
Advocate I
6 years ago

Thanks for the response, GilbertQ.  I did get and try that query in Power BI Desktop, and it worked fine there (the account is an admin on the SSAS box).  Is this something you have ever got to work?  Thanks again.