Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
multt0
Frequent Visitor

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?...
(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?

4 REPLIES 4
AntrikshSharma
Community Champion
Community Champion

@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.

Thank you,

 

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

multt0_0-1682382507769.png

Is it the right way to set it up?


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

@multt0 For that you will need to work with the IT team and whoever manages SSAS.

I build SSAS in my local(laptop)..

I created a Power BI report that live connects to SSAS created locally.

Can I publish this Power BI report and view it?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors