Gateway Does not work for my Oracle Datasourse but other datasources work

[asl10]

Words are poor! See the pictures and you will understand! I'm frustrated with this:

[v-shex-msft]

Hi @asl10,

You can try to use On-premises data gateway, it can works with oracle database:

Reference links:

On-premises data gateway

Manage your data source - Oracle

Regards,
Xiaoxin Sheng

[asl10]

Hi @v-shex-msft,

Thank you for your reply.

If you see the pictures, I'm alreday using On-premises data gateway. it works for everything else exept my oracle datasourse.

Of course being said that, when i first implemented my report it was working!

No that i have edited the query and added some other tables from files, calculated columns and measures it does not refresh at all! 

i do not know if this is the problem. But i have all the files used and others being refresh just fine from the gateway!

[v-shex-msft]

Hi @asl10,

You can try below methods to ensure where the issue is.

1. Change the domain/PC and test to connect your database and refresh data.

If it works, the issue may related to network/PC.

2. Check the dataset refresh history and the local gateway log.
If the log or history list contain the error log please share some detail content of this.

3. Try use other power bi account to connect your oracle database and refresh data.
If it works on other user's account, the issue may related to your account.

4. Try to use sqlplus or other tools to access the oracle database(test on current PC and other PCs).

If the tools also can't access to the database, the issue may related to your database.

Regards,

Xiaoxin Sheng

[asl10 · Accepted solution]

Hi again,

Thank you for your contributions. I found it. I watch this video https://www.youtube.com/watch?v=KDeidwm6Xr8 and I went and checked my datasources from Power BI desktop. Because I m using 3 tables as seperate datasources for my report I had setup 3 datasources on the gateway. It seems that one of them had the wrong path from the one on the desktop. 

Just copy the paths from the Data Source settings on the desktop and use the same ones on the gateway!