web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : kYw9sIcZ5cJv8SOp0Cpo5m
Power Platform Community / Forums / Power Apps - Microsoft Dataverse / Azure Synapse Link fai...
Power Apps - Microsoft Dataverse
Unanswered

Azure Synapse Link fails to create model.json

Like (0) ShareShare
ReportReport
Posted on 20 Jan 2023 18:16:10 by nebarnes 6

Hi, I am trying to create a new Azure Synapse Link but the model.json file is empty and the OptionSetMetadata folder is not created.

 

I was able to create a link on 16th January but due to an unrelated issue, we had to unlink and start from scratch. I am now trying to recreate the link but am having issues with an empty model.json file and no OptionSetMetadata folder.

 

I have set the advanced options to incremental, chosen a suitable timeframe and selected all of my tables in the Power Apps menu, just as I did on Monday. The link is created correctly and a container is generated on our storage account. All of the selected tables are downloaded to the container correctly.

 

However, the model.json file is never populated and the OptionSetMetadata folder and associated CSVs are missing, meaning we are unable to process the data with Azure Data Factory.

 

We havent changed anything about our setup, other than unlinking the original config. Is there an issue with deploying new links?

Categories:
Microsoft Dataverse
I have the same question (0)
  • BritonWellsLVS Profile Picture
    BritonWellsLVS 19 on 10 Mar 2023 at 13:04:09
    Re: Azure Synapse Link fails to create model.json

    Good to know - actually we had the model.json start to populate all of a sudden as well. For now we are just in development so wasn't critical

  • nebarnes Profile Picture
    nebarnes 6 on 10 Mar 2023 at 08:27:15
    Re: Azure Synapse Link fails to create model.json

    Hey, I ended up having to raise a support ticket which eventually ended up with the engineering team. I kept deleting the link and recreating it every few days and it eventually just started working randomly about a week later. When my ticket was finally answered, they could see a fault happened, but I no longer needed their help. Log a ticket and see if you get a speedier response!

     

    Support | Microsoft Power Apps

  • BritonWells Profile Picture
    BritonWells 2 on 09 Mar 2023 at 17:40:25
    Re: Azure Synapse Link fails to create model.json

    Running into this as well. Ran into some issues when adding/removing columns to a table which seemed to cause an error so dropped the link.

     

    After re-linking, tables were quickly recreated in ADLS but with an empty model.json and no OptionSetMetadata folder. Everything on the power platform side says Active. Only 11 tables and most only have <100 records.

    I have also tested creating a brand new, empty storage account (ADLS) and creating a link there - same behavior

  • nebarnes Profile Picture
    nebarnes 6 on 23 Jan 2023 at 09:14:38
    Re: Azure Synapse Link fails to create model.json

    I tried creating another link on Saturday morning and left it over the weekend. Still no OptionSetMetadata folder, and still an empty model.json file. No incremental folders have been added to our Azure Blob Storage account either, despite several time increments passing since it was created.

     

    It downloaded the initial batch of data and has done nothing else - I've checked Power Apps and can confirm that multiple tables and records have received changes since creating the new link.

  • HamidBee Profile Picture
    HamidBee 930 Super User 2024 Season 1 on 22 Jan 2023 at 14:51:06
    Re: Azure Synapse Link fails to create model.json

    Hi, I am trying to create a new Azure Synapse Link but the model.json file is empty and the OptionSetMetadata folder is not created.

     

    I was able to create a link on 16th January but due to an unrelated issue, we had to unlink and start from scratch. I am now trying to recreate the link but am having issues with an empty model.json file and no OptionSetMetadata folder.

     

    I have set the advanced options to incremental, chosen a suitable timeframe and selected all of my tables in the Power Apps menu, just as I did on Monday. The link is created correctly and a container is generated on our storage account. All of the selected tables are downloaded to the container correctly.

     

    However, the model.json file is never populated and the OptionSetMetadata folder and associated CSVs are missing, meaning we are unable to process the data with Azure Data Factory.

     

    We havent changed anything about our setup, other than unlinking the original config. Is there an issue with deploying new links?

     

    If my reply helped you, please give a 👍, & if it solved your issue, please 👍& Accept it as the Solution to help other community members find it more.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 637 Most Valuable Professional

#2
stampcoin Profile Picture

stampcoin 570 Super User 2025 Season 2

#3
Power Apps 1919 Profile Picture

Power Apps 1919 473

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans