Dataflow for Power Apps: “section Section1;…” error on create

This error for me occured when I was copying scripts and using blank queries.

This is not my image, not my database, so don’t try to access it, please 😀 I found it in Internet to illustrate the point.

section Section1; error

This message is a little bit a lot not helping. If you deploy something to PROD at night it is also very stressful. So what do we do?

We start here: https://docs.microsoft.com/en-us/azure/azure-portal/capture-browser-trace

This is to try to capture a little bit more info before we ended up contacting Microsoft support.

I was supper lucky, if it’s the right thing to say in the current situation.

After my error appeared again, I click on Developer Tools in my browser (Ctrl+Shift+I) and did a little bit of recording on the Network tab. Pressed Create button again. Got the real error.

Mine was like this:

{“error”:{“code”:101200,”message”:”Invalid Cdm model Format”,”details”:”Name of ‘Attribute’ cannot contain leading or trailing blank spaces or consist only of whitespace.”}}

I don’t know where did that white space come from. But we founded it and fixed it at the end.

Happy days!

Posted in , ,

One response to “Dataflow for Power Apps: “section Section1;…” error on create”

  1. Dave Avatar
    Dave

    Do you have any more details on how you found and fixed the white space? I replaced the white space in my column names by trimming them and replacing spaced between characters with underscores. Starting to lose my sanity over this!

    Like

Leave a comment