Data source access error

[Anonymous]

Hello Everyone,

                        I am looking to see if anyone can help me resolve this issue . I am trying to publish a Power BI report where one of the sources for the report hooks into our Oracle database. I have set up a On-premises gateway and mapped the source accordingly and there is no Gateway error. 

When i try to refresh the datasource i do not get any error too , but when i try to load the visuals it ends up telling me the following

I am kind of struck at this point and not able to proceed any further. I appreciate the assistance in advance.

Thanks

[v-luwang-msft]

Hi @Anonymous ,

About this error,the official article contains a detailed description, as well as treatment options, which you can refer to at:

Error: Data source access error. Please contact the gateway administrator.

If this report makes use of a live Analysis Services connection, you could encounter an issue with a value being passed to EffectiveUserName that either isn't valid or doesn't have permissions on the Analysis Services machine. Typically, an authentication issue is due to the fact that the value being passed for EffectiveUserName doesn't match a local user principal name (UPN).

To confirm the effective username, follow these steps.

1. Find the effective username within the gateway logs.

2. After you have the value being passed, validate that it's correct. If it's your user, you can use the following command from a command prompt to see the UPN. The UPN looks like an email address.

whoami /upn

Optionally, you can see what Power BI gets from Azure Active Directory.

1. Browse to https://developer.microsoft.com/graph/graph-explorer.

2. Select Sign in in the upper-right corner.

3. Run the following query. You see a rather large JSON respons

https://graph.windows.net/me?api-version=1.5

     4.Look for userPrincipalName.

If your Azure Active Directory UPN doesn't match your local Active Directory UPN, you can use the Map user names feature to replace it with a valid value. Or, you can work with either your Power BI admin or local Active Directory admin to get your UPN changed.

And you could refer the following article:

Manage your data source - Oracle

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Best Regards

Lucien

[tctrout]

If the dataset maps to the gatway and you have green checks across the board, I would double check that the account you are using to wire the Dataset to the Gateway is listed as a User on the Gateway set up.

If it is, unfortanutely I cant assist anymore and this may be specific Oracle connects which I do not have experience in.

[Anonymous]

I did map the dataset to the Gateway.

[tctrout]

You confirmed that you have a gateway and it works.

However, did you confirm that your specific report / dataset is mapped to that gateway connection?  When you publish a report initially, you need to manually map the dataset to the gateway.  If the gateway is configured properly with the connection strings used in the report, the drop list options will be there for you to choose.

If you dont see options when mapping the dataset to the gateway, I would review the data sources in the PBIX and ensure that the strings are exactly as configured  in the gateway.