Hello,
my company is currently facing a strange interaction.
I got some PowerBi Reports from Finance and they wont them published in Teams.
We already used MySQL Reports and had no issues whats so ever.
My Implementations looks as following:
On Prem Connector on AAD and DC Server.
AAD User is logged in and an lokal Service User is in use.
The Report got published in a spezific workgroup.
Gateway is assigned and online(Is working with other Reports already)
Datasource is a Analysis Service on a SQL Server.
The provided local User is sql server admin and a connect via sql server management is possible for example.
The Datasource is online aswell.
But as soon as i open the report i got the following error message:
Where could my mistake be. Got an local connection. Gateway is working with other reports but this one wont work.
Best regard,
Michael Seidel
Solved! Go to Solution.
Hi @Mamabox ,
When you have "Live connection" set up people viewing the dashsboard must have access to the data source. Please check if the service account(s) you're using for SSAS/EGW has "Read" permission on the AD user in acrtive directory. I had an issue this week where one user had "Read" for "Authenticated Users" checked, and the other had not (and that user's connection failed).
refer:
Best Regards
Lucien
Hi @Mamabox ,
When you have "Live connection" set up people viewing the dashsboard must have access to the data source. Please check if the service account(s) you're using for SSAS/EGW has "Read" permission on the AD user in acrtive directory. I had an issue this week where one user had "Read" for "Authenticated Users" checked, and the other had not (and that user's connection failed).
refer:
Best Regards
Lucien
User | Count |
---|---|
135 | |
59 | |
56 | |
55 | |
46 |
User | Count |
---|---|
128 | |
76 | |
55 | |
54 | |
50 |