如何通过电源查询在此处加载数据？ [英] How was the data loaded here with power query?

问题描述

我们的任务是能够连接到Power BI中的HFM。我找到了这篇文章：

We have a task to be able to connect to HFM in Power BI. I found this article:

> https://poweronbi.com/2016/04/from-hyperion-planning-or-hyperion-financial-management-to-power-bi/

但是我不明白如何/可以将数据库表从HFM加载到PowerBI。就陈述而言，在步骤1-2中没有任何演示或解释：

but i dont understand HOW the database tables were/can be loaded from HFM into PowerBI. This is as far as the statement goes, without any demo or explanation in step1-2:

我已经附上了HFM数据的屏幕截图基本，则可以加载
左列中列出的所有表，并使用
Power Query将其加载到Power BI。

I have attached a screenshot of the HFM data base, and you can load all the tables listed in the left column and load it to Power BI with Power Query.

PowerBI中没有HFM连接器。

There is no HFM connector in PowerBI. so how were they able to connect to begin with??

推荐答案

我认为没有任何方法可以直接连接到？ HFM。您可以连接到存储HFM数据的Oracle服务器。这与您共享的链接中列出的信息相同。如果您想了解有关如何通过Power BI连接到Oracle服务器的详细信息，则以下链接应为您提供帮助：

I don't think there is any way to connect directly to HFM. You can connect to the Oracle server where the HFM data is stored. That's the same information listed in the link you had shared as well. If you want details on how to connect to an Oracle server from power BI the following link should help you out:

https://www.edureka.co/community/41702/how-to-从power-bi连接到Oracle数据库

这篇关于如何通过电源查询在此处加载数据？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！