Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
@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"
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?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.