Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

there was a data source access error please contact the gateway administrator (direct query Mode)

Hello,

 

My Report published in Power BI service has a data source of  Oracle ADB. I have used direct query mode.

When I try to view the report I am getting the error:

there was a data source access error please contact the gateway administrator direct query.

 

Subramaniyam_0-1668756216760.png

 

Even refreshes are working fine (As gateway is connected)

Subramaniyam_1-1668756277379.png

Does anyone have any idea why I cant view my report in the Direct Query in Power BI Service?

 

5 REPLIES 5
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

Is this a temporary issue?

You may need to enter the password and username again to reconfigure the gateway.

 

Best Regards,
Community Support Team _ Eason

Anonymous
Not applicable

No, it is a not temporary issue.

 

I have tried to reconfigure gateway in Power BI Service with username and password. Still It's not working on direct query.

As I have a power bi pro license I will go for official support from Microsoft.

Anonymous
Not applicable

Yes, I am using the same connection. (Username mentioned for connection and data source for gateway is same).

 

When i am doing the same with Import Mode i can see the report.

 

I am not able to understand why it is not working for direct query.

 

You can raise an issue at https://issues.powerbi.com . If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/

lbendlin
Super User
Super User

Are you sure you are using the same connection for the Direct Queries and the refreshes?  

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.