Forum Discussion
Fabric pipeline
I have a Business central big database , how i can create a dataflow / pipeline then store this data(contain many tables ) in a data warehouse to consume it in power bi?
Hi Anonymous,
Thank you for reaching out in Microsoft Community Forum.
Thank you Cookistador for the helpful response.
Please follow below steps to Load Business Central Data to a Data Warehouse for Power BI;
1.Create a Dataflow Gen2 in Power BI and connect to Business Central to select the required tables.
2.Store the data in a Lakehouse (Microsoft Fabric) or a Synapse SQL/Data Lake destination.
3.Schedule refreshes or pipelines to keep the data up to date automatically.
4.Build Power BI reports by connecting to the Lakehouse/Synapse using DirectLake or SQL endpoint.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
5 Replies
- Cookistador
Super User
you can use OData Web Services or SQL database then use a copy activity in a pipeline
If you use sql, you will need a data gateway
Hi Anonymous,
Thank you for reaching out in Microsoft Community Forum.
Thank you Cookistador for the helpful response.
Please follow below steps to Load Business Central Data to a Data Warehouse for Power BI;
1.Create a Dataflow Gen2 in Power BI and connect to Business Central to select the required tables.
2.Store the data in a Lakehouse (Microsoft Fabric) or a Synapse SQL/Data Lake destination.
3.Schedule refreshes or pipelines to keep the data up to date automatically.
4.Build Power BI reports by connecting to the Lakehouse/Synapse using DirectLake or SQL endpoint.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.Hi Anonymous,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please "Accept as Solution" and give a 'Kudos' so other members can easily find it.
Thank you,
Pavan.Hi Anonymous,
I wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If the community member's answer your query, please mark it as "Accept as Solution" and select "Yes" if it was helpful.
If you need any further assistance, feel free to reach out.
Please continue using Microsoft community forum.
Thank you,
Pavan.
