Mass dump data in a single attempt from Business Central to Power BI Warehouse

[supriyapandey19]

Hi,

We have the requirement of loading all the data from Business Central to Power BI Warehouse. We want to dump the data in a single attempt from BC to warehouse. 

We tried importing the .bacpac file from Business Central to Azure SQL DB and then to Power BI Warehouse for historical load, but the tables are getting imported in it's raw form and not how we see the table names and structure when we pull it using Business Central Online Connector in Dataflows Gen2 for incremental load.

We want to import the data with performance optimized way for doing single historical load and then requirement based incremental load.

Any references, links, solutions would be appreciated.

Thanks.

[Anonymous]

Hi @supriyapandey19 ,

It sounds like you’re dealing with a complex data integration task. Here are some steps and resources that might help you achieve a performance-optimized historical load and incremental load from Business Central to Power BI Warehouse:

1.Use Business Central APIs: For incremental loads, leverage Business Central APIs. Configure API queries with read-scaleout and use the field to filter only the data that has changed since the last loadLastModifiedOn

2.Set Up Dataflows: Use Dataflows Gen2 in Power BI for incremental data loads. This allows you to pull data incrementally and keep your dataset up-to-date without reloading the entire dataset
Below is the link will help you:

insightsoftware.com

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.