Forum Discussion
there was a data source access error. please contact the gateway administrator
Community ChampionIt looks like an Entreprise Gateway running on your desktop and mapping to a different Cluster!
What is STAR MODEL?
A personal Gateway should look to something like this
no mapping is needed if it is connected directly to the source and the DB
So you need to secure which way you want to connect to your source.
hmmm, i already have Enterprise Gateway on my desktop,
k lets try again. This is my new configuration:
This is my users configuration:
This is my data base in Analysis services:
Another thing to know is that my PC is not in any DOMAIN is just a user "victo" with admin permissions
I have test my connection again and it say its ok but there is the problem on this view:
Hi victor-15-a ,
According to the error message, the user who is currently viewing the report didn't have permission to access the data source. Whether this user was added to the Role list of the analysis service model? The email address of the user sign in Power BI must match a defined user principal name (UPN) within the local Active Directory domain. Are the report viewer account and the account DESKTOP-7L703JB/victo from different domain? If it does not match, you can map user names for Analysis Services data source.
How authentication works with Analysis Services live connections
Best Regards
I have check that the user(victo) im using have permission to access the data source, there is the photo
This user(victo) was added to the Role list in the analysis service model
my user sign in Power BI is map user names like this:
and still the same error
Hi victor-15-a ,
Please try to update the version of your gateway to the latest one. And please map user with rule type "Effective user names" as below screenshot, you refer the following video to do it.
Map user names for Analysis Services data sources
Gateway: UPN mapping everyone to the same admin user
Best Regards