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.
Comments
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
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
Business Central Team (administrator)