Today I would like to briefly share a new release news, Business Central connector enabled in Power BI Dataflows is generally available.
About two weeks ago, minor update 20.3 for Business Central 2022 release wave 1 has been released! More details: Cumulative Update Summary for Microsoft Dynamics 365 Business Central（July, 2022）
Although not mentioned in What’s new and planned for update 20.3, I saw it on Twitter this morning.
You can now access data from Business Central in a more seamless and proficient way by creating dataflows that you share across different reports and dashboards.
The Business Central connector is now available in Power Query Online (Power BI Datamarts and Dataflows) so that you can create far more performant and flexible data source configurations, not least when multiple users access or refresh data from Business Central.https://docs.microsoft.com/en-us/dynamics365-release-plan/2022wave1/smb/dynamics365-business-central/business-central-connector-enabled-power-bi-dataflows
In fact, this is a feature that has more votes in Business Central ideas, great work.
Add Business Central as a Data Source in DataFlows
Let’s see more details.
A dataflow is a collection of tables that are created and managed in workspaces in the Power BI service. A table is a set of columns that are used to store data, much like a table within a database. You can add and edit tables in your dataflow, as well as manage data refresh schedules, directly from the workspace in which your dataflow was created.
To create a dataflow, launch the Power BI service in a browser then select a workspace from the nav pane on the left, as shown in the following screen. You can also create a new workspace in which to create your new dataflow.
Now you can see that Dynamics 365 Business Central has been added.
It’s great! Give it a try!!!😁
1. In previous version
2. Dataflows are not available in my-workspace in the Power BI service
More about Create a dataflow using define new tables from MS Docs.
Hope this will help.
Thanks for reading.