Dynamics Community Forum Thread Details

Azure Synapse Link for Dataverse with FnOTables

Dear Dynamics 365 Community :-)

I have connected our Finance & Operations environment to a Synapse Analytics workspace through the make.powerapps.com "experience" like the documentation explains.

Initially, I have only synchronized [custtable], and according to make.powerapps.com the table is available in Azure Synapse Analytics.

When I open the Azure Synapse Analytics workspace associated with our FnO environment, I can see the link under Lake databases, but when I expand the Tables folder, [custtable] is not available. I have tried exporting other tables like [inventtable] and [custgroup], but they never show up in the Tables folder in Synapse Analytics.

If I go to the underlying datalake, a folder structure with partitioned [custtable] information has been created, along with a model.json file and a Changelog catalogue.

Can anybody explain why [custtable] won't show up in my Azure Synapse Analytics workspace. What am I doing wrong?

I have successfully mapped our Dynamics Sales (CRM) environment to the same azure synapse analytics workspace, and here I am able to query the [account] table with SQL statements without any issues.

I have attached a few screenshots to document the setup.

/Jakob Jørgensen, Data warehouse & BI Developer

Quick Links