Forum Discussion
Help Combining Business Central and SQL Data
Hi,
A few things to try...
1) Make sure your gateway has been updated to the latest version.
2) Check privacy levels match on both data sources.
3) Does the gateway have the same permissions on the new data source as you have locally. (Sometimes hit weird issues with SQL RLS).4) Wrap the last lines of each source query in Table.Buffer to force the engine to load both fully before merging.
I suspect however that the above might not work.
If not try to build 3 dataflows. First 2 are straight ingests of esch seperate source.Then reference the 2 ingest data sources in a 3rd dataflow to so the merge. This allows power bi to bring everything in (and stores in a data lake) and then merge cloud side. Whereas your exisiting setup is loading everything into memory in the gateway engine and doing the merge there (would be worth watching memory utilisation during a refresh to see if it's maxing out).
Drop me a direct message if you need help with any of the above.
Hi,
A few things to try...
1) Make sure your gateway has been updated to the latest version.
2) Check privacy levels match on both data sources.
3) Does the gateway have the same permissions on the new data source as you have locally. (Sometimes hit weird issues with SQL RLS).
4) Wrap the last lines of each source query in Table.Buffer to force the engine to load both fully before merging.
I suspect however that the above might not work.
If not try to build 3 dataflows. First 2 are straight ingests of esch seperate source.
Then reference the 2 ingest data sources in a 3rd dataflow to so the merge. This allows power bi to bring everything in (and stores in a data lake) and then merge cloud side. Whereas your exisiting setup is loading everything into memory in the gateway engine and doing the merge there (would be worth watching memory utilisation during a refresh to see if it's maxing out).
Drop me a direct message if you need help with any of the above.
Using dataflows worked! Thank you so much.
