Forum Discussion

RickyRhys's avatar
RickyRhys
Regular Visitor
4 years ago

Error connecting to Azure Analysis Services from Power BI Report Server

I have created a report in Power BI Desktop (RS edition) and connected it to our Azure Analysis Services Model. I connected using my Microsoft Account (AAD?) and can run the report without issue. H...
Report Server + AAS
v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, RickyRhys 

 

If you use desktop for service, You can do it. But I think it’s hard to do it in the report server. Report server is on-premises solution for reporting.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If problem still persists, pls let me know.

 

Best Regards,
Community Support Team _ Janey

RickyRhys's avatar
RickyRhys
Regular Visitor
4 years ago

Hi Janey,

According to the Microsoft Documentation, SQL Server Analysis Services is a supported datasource for Power BI Report Server.

 


I still have this issue as it's imperative that we can use Row-Level security for these reports.

Using a hard-coded Username and Password with Basic Authentication is not secure for us.
Any help greatly appreciated.

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    Hi, RickyRhys 

     

    Did you look down?

    Here are the methods you can try:

    If you have new questions, you can re-post a thread, which will make the thread active again and more engineers will participate. I'm no longer in charge of the RS threads, there will be more professional engineers in charge of you.

     

    Best Regards,
    Community Support Team _ Janey