cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

How to use a query in connection credentials with Oracle on Power BI web service

I have a connection setup to an Oracle DB in Power BI desktop.  During the connection setup it allows me to use a SQL query which works well...when I publish the report to the online platform it connects to the datasource fine through my gateway (and will even refresh), but when I go to view the report it gives me the following error:

Capture.PNG

 

I believe this may have something to do with the SQL query that was written during the connection parameters in Power BI Desktop, but I was not able to create the query in the web service.

 

Does anyone have experience with this error or using a SQL query in the Power BI web service?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Regular Visitor

Re: How to use a query in connection credentials with Oracle on Power BI web service

Thanks for the tip.  The log says it cannot find the .net framework data provider, but does not tell me which one.

 

I ended up switching from direct query to imported and got it to work.

View solution in original post

2 REPLIES 2
Highlighted
Super User II
Super User II

Re: How to use a query in connection credentials with Oracle on Power BI web service

Hi @sublimer,

your on-premise data gateway has its own log. I'd start there.

Under Diagnostics, there is also an option for Additional logging, which you can use for debuging - more about under Additional Logging.

Highlighted
Regular Visitor

Re: How to use a query in connection credentials with Oracle on Power BI web service

Thanks for the tip.  The log says it cannot find the .net framework data provider, but does not tell me which one.

 

I ended up switching from direct query to imported and got it to work.

View solution in original post

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors