Import JDE Tables

[RGL]

Hi,

I am fairly new at Power BI but have learn quickly everything DAX... what I'm strugling with is all the connectivity stuff, gateways, on-premises, all those kind of things... So, can you explain me how to import a JDE table to Power BI desktop?

[mwegener]

 Hi @RGL ,

start with Power BI Desktop and connect to the JDE database. Depending on the implementation, this can be an Oracle or MS SQL database.

Do you have the relevant connection information?

This page could help you to find the tables you need.

http://jderef.com/

[RGL]

Hi  @mwegener 

I think it's Oracle, but I go to Get Data, Oracle, and I get this

[mwegener]

Hi @RGL ,

yes Oracle is a bit tricky, you need the right database driver on your computer.

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database