Share
Report
7Dear 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
I have the same question (0)
All responses (
Answers (
