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



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.
Needs Votes
Ideas Administrator

Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future. Best regards, Business Central Team