Forum Discussion
Issues connecting to On-Prem Tabular Model
Anonymous,
Everyone is inside the network, physically at the same location.
They autheticate against AD using their local machine, then login to PowerBI.com.
All 5 users included on the process are authenticating the same way as the above.
2 users are able to get data from on-prem sources.
3 users are not able to get data from on-prem sources.
All,
After 1 month and 2 days, we finally got to the bottom of the issue.
I opened a ticket with Microsoft to troubleshoot the issue. The engineer I was working with worked on comparing outputs of whoami /all across different users (the ones experiencing the issues vs. the ones not experiencing the issue) to see what kind of membership at the domain level one user had that the other didn't. Unfortunatelly, we did not get anywhere with this approach.
The Engineer then brought someone from Directory Services into the issue. The DS Engineer requested us to add the “Authenticated Users” group to the “Pre-Windows 2000 Compatible Access” group and like magic, users were able to access data on-premises from PowerBI.com.
After the above was done, I introduced two new users to the equation by:
- Assigning user a PowerBI Pro account
- Added user to the Data Management Gateway group on the machine where the Data Management Gateway service is running
- Added user to Read Role on SSAS
- Shared a test dashboard connecting to SSAS on on-premises with the two users
The users are now in business. We can now roll this out to production.
Is anyone from Microsoft watching this forum? Is the above documented anywhere? If not, this should be documented somewhere.
Anonymous Bjoern
igordossantos Thanks for the loop in to the resolution.
Great - thank you for the detailed investigation and sharing it here in the community!
