Forum Discussion

thc's avatar
thc
Frequent Visitor
9 years ago
Solved

Issues when connecting to Analysis Services 2016

Hi   I think this is the appropiate place to put this, so here goes.   I have a site, where I have installed the on-premises PowerBI Gateway, and added a data source, the Analysis Services instan...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi thc,

    What edition of SQL Server 2016 in your scenario ? Also, please check that if the email address you use to sign in Power BI matches the User Principal Name (UPN) of the local Active Directory Domain. For more details, please check this article.

    In addition, you can connect to SSAS from Power BI Desktop, then create reports there and publish reports to Power BI Service, then use the gateway to refresh the dataset.


    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi thc,

What edition of SQL Server 2016 in your scenario ? Also, please check that if the email address you use to sign in Power BI matches the User Principal Name (UPN) of the local Active Directory Domain. For more details, please check this article.

In addition, you can connect to SSAS from Power BI Desktop, then create reports there and publish reports to Power BI Service, then use the gateway to refresh the dataset.


Thanks,
Lydia Zhang

thc's avatar
thc
Frequent Visitor
9 years ago

Hi Lydia

 

It's 2016 Standard edition.

But it works now, it was the mapping of names. I thought it only necessary to map different accounts to other domain accounts, but of course in this case the UPN and o365 domains does not match. I should have caught that.

 

Thanks a lot for the help, much appreciated.