Forum Discussion
PowerBI Gateway Error - My Workspace
Hi Everyone,
I am currently facing this issue when I publish to Service and couldnt have visuals loaded because report is not able to access data source...
"This Report Couldnt access the data sources becuase it doesnt have permission"
This is in my Workspace and I do not have Pro License for the client I am working for
I have Standard Mode Gateway Installed and add all datasources to it... these data sources work fine from PowerApp however they do not work in PowerBI report...
All datasources are on prem sql server(dev & prod)
I click on Choose another data source and it does show all my datasources when I select them and click Apply it does accept it however cant get rid of this error .. test connection seems to be successful in Manage Gateways area
Anyone has any idea on this one ... please comment your suggestion
2 Replies
Very difficult to troubleshoot, I would open a support ticket. You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".Hi Anonymous ,
Please check the following pints:
- if you have installed the latest version of gateway (3000.37.35).
- if the data source information 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.
