Forum Discussion

multt0's avatar
multt0
Frequent Visitor
3 years ago

Gateway Connection - Connect Live SSAS

I have built a Power BI report using SQL Server on my local machine(Laptop) with Analysis Services,

and I want to publish it to confirm that RLS is working properly.

I followed this website : https://learn.microsoft.com/en-us/analysis-services/tutorial-tabular-1400/as-lesson-11-create-roles?view=asallproducts-allversions
(I understand that RLS is not working because I don't have an email at Sample Data.

Therefore, even if I deploy the model without using RLS, I still encounter the same below error...)

 

 

After publishing, I realized that I needed a gateway,

so I installed the On-premises data gateway and configured the data source.

 

However, I am seeing the message "this report couldn't access the data source. contact the author to have it fixed".

I believe it should be showing the data from my local machine...

 

How can I resolve this issue?

Need Help

4 Replies

  • AntrikshSharma's avatar
    AntrikshSharma
    Community Champion
    3 years ago

    multt0 SSAS on premise can only authenticate using Windows credentials so you need to setup Local Active Directory that maps PBI Service Account with Windows account & UPN that has access to the SSAS Model.

    • multt0's avatar
      multt0
      Frequent Visitor
      3 years ago

      Thank you,

       

      I set up UPN at Data Source Setting like 
      Replace : "windows account", With : "PBI Account"

      Is it the right way to set it up?


      How  to setup Local Active Directory that maps PBI Service Account with Windows account?