Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Data Connections Cockpit Cubeware

Hi guys! I am currently trying to create a report from data that is mainly available via custom reports in a tool called Cockpit (from Cubeware). Cockpit creates reports via SQL codes from databas...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi @ Beat77,

 

You mentioned that reports can be exported to Excel in Cockpit, and Power BI supports getting data from Excel.

Therefore, you can use the Excel export from Cockpit as a data source for Power BI to create reports in Power BI.

Quickstart: Connect to data in Power BI Desktop - Power BI | Microsoft Learn

 

Power BI also supports connecting to Oracle databases.

Therefore, you can connect Power BI Desktop directly to your Oracle database to create reports.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Learn

 

Best Regards,

Dengliang Li

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Denglian!

 

You are right, I know that I could connect to either Excel or Oracle. Excel is no option as we are talking about "live" data - so downloading the report every let's say month and then do the Power BI reporting is no option. Oracle would make sense but I would have to recreate the report from Cockpit in Oracle. So before doing that I wanted to know if I can't connect to Cockpit directly. The reports in cockpit have an SQL query behind them which simply gets data from databases like Oracle. But I never heard of an Oracle data connection in Power BI. Thats why I posted this question. 

 

Thanks and BR