- 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
User | Count |
---|---|
21 | |
16 | |
15 | |
15 | |
12 |
User | Count |
---|---|
42 | |
25 | |
22 | |
18 | |
11 |