Forum Discussion
sublimer
7 years agoRegular 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 conn...
- 7 years ago
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.
Nolock
Resident Rockstar
7 years agoHi 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.
sublimer
7 years agoRegular Visitor
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.