Forum Discussion
Oracle Connection - gateway config in service
Anonymous Direct query is not supported by Personal gateway .
Refer this article -https://community.powerbi.com/t5/Desktop/Personal-Vs-Enterprise-Gateway/m-p/767443 and please close this thread 🙂
I am getting the first screen "You don't have any data gateways" - although I have published reports before but they were done under my windows AD account and they were for accessing excel data sources that were located on my network share.
The "Azure ID\POWERBI login for the tenant" - where can I can find that account? Just as a note, Power BI Pro was not installed by me, so I would appreciate your continued feedback so I can ask my IT admins.
Anonymous AzureID \PowerBI login would be your [email protected] ( example: [email protected])
You have to ensure your Powerbi report also uses similar connection like I have stated in my first post .
Once you publish the report in PowerBi Service you have to map the data gateway if you use data gateways.
Ask the person who setup the gateway if you dont have access to provide you exact connection details (server and database name).
Error: Report could not access the data source because you do not have access to our data source via an on-premises data gateway.
This error is usually caused by one of the following:
The data source information doesn't 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's 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.
please see below...
1. i rechecked my power bi desktop login settings - image 1 below.
2. i compared it to the apps.powerbi.com setup under "manage connections and gateways" to made sure it matched step 1 - it does - image 2 below.
3. Under the "manage Data Sources & Gateway", - I checked that it was online and the manage users had my ID in it - image 3 below.
4. I checked my on-premises (personal) gateway - it seems to be all up, I also republished my report after signing into the gateway again - image 4 below.
5. Under apps.powebi.com -- I checked the dataset and it still does not show my gateway, I also clicked on "recreate Cloud data sources" and that did not work either - image 5 below.
Anonymous You need to match what is in the gateway . Check with the person who setup gateway and use the same server and database name in your desktop report.
Also I dont see Gateway cluster name in your gateways screenshot.
server and database name need to match between the data source defined for the on-premises data gateway
also forgot to add in my response - I do not have a gateway cluster.