Forum Discussion

lgargano's avatar
lgargano
Regular Visitor
8 years ago

PBI report using Oracle database as data source

Hello guys!     I am in face in some issue with PBI report using a Oracle database as data source. Basically, I’ve created a report connected on Oracle database using PBI Desktop, I can work with...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi lgargano,

 

Please check the detailed error message via clicking "See details".

 

This could happen if the data source was removed, renamed, moved, offline, or permissions have changed.  Please check that the source is still in the location we are pointing to and you still have permission to access it. If that isn't the issue, the source may be slow. Try again later during a time when the load on the source is smaller. 

 

By the way, if using import mode to connect to Oracle, does issue persist on service?

 

Regards,
Yuliana Gu

lgargano's avatar
lgargano
Regular Visitor
8 years ago

Hi, v-yulgu-msft

Thanks for your awnser!

I've clicked on error message and I got the error below:

 

 

 

 

I am 100% sure that the data source is OK because I can make the query on database and also I can see the data by PBI Desktop. I can not use option import mode, I need this info in real-time, so I used option direct query.

 

Thanks!

 

Leonardo.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi lgargano,

     

    The error message prompts that "Cannot connect to gateway data source", did you configure gateway in your scenario?

     

    Regards,
    Yuliana Gu