search

Bertverbeek4PS / bc2adls

Exporting data from Dynamics 365 Business Central to Azure data lake storage or MS Fabric lakehouse
MIT License
49 stars 20 forks source link

Mix of multiple company tables and common tables #81

Closed lhammerbh closed 7 months ago

lhammerbh commented 7 months ago

Hi Bert When running the consolidation notebook, I get an error, when it is processing the data from common tables that does not contain the $Company field. Common tables are e.g. AccessControl, Company and User.

I have modified the notebook, so that it checks whether a delta table contains the $Company field. If yes, it does the current processing, if no, it does the same processing, but not using the $Company field.

This updated notebook is attached. The extension is changed from .ipynb to .json in order to upload the file to Github, so you need to rename it back to .ipynb.

CopyBusinessCentral.json

Bertverbeek4PS commented 7 months ago

Really thanks for the help @lhammerbh! Indeed that part was missing in the script. Thanks for providing the solution. I have added it to the main branche.