As from today, Microsoft Dataflows support Business Central, out of the box:
What is a Dataflow you might think?
Well a Dataflow is basically Power Query online.
All tasks you typically perform in Power BI Desktop with Power Query (ETL) you can do in a dataflow and the dataflows are stored online, in the Power BI Service. Then using Power BI Desktop or Excel you can connect to the dataflows and underlying datasets.
You could say it’s like a mini datawarehouse you create in the Power BI Service and consume in all you reports.
So instead of always doing ETL in every report over and over again, and importing/refreshing the same data in different reports (manual or scheduled), you do it only once in a dataflow and recuse it wherever you want to.
More information on dataflows is available here:
- Power BI dataflows are an enterprise-focused data prep solution that enables an ecosystem of data that’s ready for consumption, reuse, and integration
- Create reusable transformation logic
- Create a single source of the truth
- Work with large data volumes
- Prevent analysts from having direct access to the underlying data source (Business Central)
Dataflows are supported for Power BI Pro, Premium Per User (PPU), and Power BI Premium users. Some features are only available with a Power BI Premium subscription (which is either a Premium capacity or Premium Per User (PPU) license).
Try it out!
All you need is a Power BI Pro sku, then create a workspace in the Power BI Service, and then you have the option to create dataflows:
You can for example create different dataflows for master data and transactional data:
and have them refreshed at different intervals.
Cool, isn’t it!
Thanks everyone for voting on this idea: