Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.

 

 

Even refreshes are working fine (As gateway is connected)

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

 

Need Help

5 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

     

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    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's avatar
      Anonymous
      Not applicable
      3 years ago

      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.