Forum Discussion
Tvisual
7 years agoRegular Visitor
Report Cannot access Data because it does not have permission
I have published a power BI file on app.powerbi.com
The report contains direct querries. When I tried viewing at app.powerbi.com them it tell me that report couldn't access the data because it does not have permissions. Any help in this?
My other report is able to connect and two cannot connect.
1 Reply
- v-lili6-msftCommunity Support
hi, Tvisual
This is usually caused by one of the following.
- The data source information does not match what's in the underlying dataset. The server and database name need to match between the data source defined for the on-premises data gateway and what you supply within Power BI Desktop. If you use an IP Address in Power BI Desktop, the data source for the on-premises data gateway needs to use an IP Address as well.
- There is no data source available on any gateway within your organization. You can configure the data source on a new or existing on-premises data gateway.
https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#reports
https://community.powerbi.com/t5/Service/Unable-to-connect-to-SSAS-Tabular-from-Service/td-p/551610
Best Regards,
Lin