Forum Discussion
Power BI This report could not access its data source. please contact developer.
Hello All,
It woluld be great help if someone can help me in publishing and distribute Power BI Report using SSAS Tabular Model as backend with latest Gateway released as on 15-Feb-2016.
Presently I am getting below error:
Power BI This report could not access its data source. please contact <Developer>, the author, to have it fixed.
I have SSAS 2012 (Tabular) installed on my premises and I developed report and published on cloud and able to access them using my account after configuring SSAS tabular data source but when I create content pack and share the same with others in my organiation, they are getting above error. Though they can see link under Reports and Datasets, in-fact report section are also available but all shows X icon. When I click on Technical details I see below:
Activity ID4f4c83ba-8d75-4e22-a1fa-20b1992d5e7a
I have configured Enterprise Gateway, earlier I had PowerBI SSAS Connector but I guess Microsoft has replaced it with PowerBI Enterprise Gateway.
I have tried using Power BI SSAS Conector also from other machine but again getting error at the final step of SSAS connector.
The data at the root level is invalid. Line 1, position1.
Though I am able to see data source in Power BI cloud but when I open it to select data, I see below error:
Earlier SSAS connector was working before Microsoft removed SSAS Connector from download section.
raghavendrasrb,
Was it connected to SSAS? If so, if you have "Live connection" set up people viewing the dashsboard must have access to the data source. You can use "import" instead and scheduled refresh to avoid this.
You may have solved your issue already, but 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).
7 Replies
I shared my dashboard to my team, few members able to see the dashboard. But few members are getting this error.
Please let me know how to troubleshoot this error.
Thansk
Raghav
raghavendrasrb,
Was it connected to SSAS? If so, if you have "Live connection" set up people viewing the dashsboard must have access to the data source. You can use "import" instead and scheduled refresh to avoid this.
Hi,
I have the same issue with multidimensional SSAS. After publishing the report, created with Power BI Desktop, in Power BI service I get the error: "This report could not access its data source. please contact <Developer>, the author, to have it fixed.". I connect to Power BI Service with [email protected], I've also added UPN 'company2.onmicrosoft.com' to my AD account COMPANY/username. Any advice?
vaidag,
Could you further explain the issue you're running into? In specific this part" I've also added UPN 'company2.onmicrosoft.com' to my AD account COMPANY/username"?Hello,
now we are trying to connect from our companie's Office 365 tenant, so I connect to Power BI service as: [email protected].
My AD account is: COMP\jonasp. We've added the UPN ([email protected]) to my AD account. I still get the same error, when I try to view the report from Power BI service.Gateway log and SQL Profiler both gives the same error message: The user name or password is incorrect.
hi prakchan499,
Please send us your Gateway logs to [email protected]. Logs can be found at: C:\Users\PBIEgwService\AppData\Local\Microsoft\Power BI Enterprise Gateway\EnterpriseGateway*.log
