85
Currently it is not possible to connect a DataFlow directly to Business Central, like it is in Power BI Desktop:

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create#create-a-dataflow-using-define-new-entities

https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

There's the ODATA connector, but that is kind of 'buggy' since it does not always load the data, when connecting to the Company webservice, to create a multi-company report.

A great advantage of DataFlows is to create reusable transformation logic that can be shared by many datasets and reports inside Power BI. You can create a single source of the truth by forcing analysts to connect to the dataflows, rather than connecting to the underlying systems, providing you with control over which data is accessed, and how data is exposed to report creators.

And performance wise it also has a lot of advantages.
STATUS DETAILS
Planned
2022 Release Wave 1
Ideas Administrator

Thank you for this suggestion! We are looking at a way to enable this in one of the future versions of the connector (not related to the Business Central version).

Microsoft

Comments

S

I couldnt aggree more. The new updated Business Central connector for Power BI Desktop released in June 2021 updated (https://powerbi.microsoft.com/en-us/blog/power-bi-june-2021-feature-summary/) is great. If this connector is added to dataflow, we can reuse the transformation logic across multiple datasets and reports!

Category: Reports and Business Intelligence

S

What do I need to do to cast my vote for this please? I can't vote for it even if I'm logged in.

R.

Category: Reports and Business Intelligence