Forum Discussion

SELECTDBA's avatar
SELECTDBA
Icon for Advocate I rankAdvocate 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
Icon for Super User rankSuper 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
    Icon for Advocate I rankAdvocate 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.  

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      6 years ago
      Hi there

      Have you mapped the username on the data source in the Gateway on the Power BI Service?
      • ChristianDGreat's avatar
        ChristianDGreat
        Icon for Resolver I rankResolver I
        4 years ago

        Do you have any docs for this? we are getting the same error.