- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
there was a data source access error.please contact the gateway administrator
Hello,
I want to create one report with SSAS (hosted on our own server). using Live connection. I've configured the on premises gateway. I have tried all the things which I found related to this. I am geeting "there was a data source access error.please contact the gateway administrator" error.
Cinfigureation I have:
- Server where SSAS is configured.
- Admin User (has admin user of the srever as well as added in SSAS as admin: "anujgarg")
- Enterprises on premises gateway configurwed with my email and Gateway servicve account is "anujgarg") and emailID say anuj@garg.com
- I have tried configureing datasource with customdata as well as with the EffectiveUserName. I have logged in as anuj@garg.com
Error: https://prnt.sc/hmEUN5D5k0CK
Please help me in get it work I assume I am missing some small peice which is causing this.
Thanks.
Anuj Garg
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @anujgarg
Is your SSAS On-Premise connected to an Active Directory domain?
In order for it to work it needs to be connected and signed into a Active Directory domain
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @GilbertQ
No it’s not connected to the Active Directory Domain. It is necessary to be connected and signed into a Active Directory domain? Is there any way to work it with AD?
Thanks,
Anuj Garg

Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.

User | Count |
---|---|
53 | |
23 | |
22 | |
20 | |
18 |
User | Count |
---|---|
46 | |
21 | |
20 | |
20 | |
18 |