Microsoft Fabric existing connection Autodesk Construction Cloud not selectable in Dataflow Gen2

[floris_van_der_zwaard]

Hello,

We succesfully set up a new connection to Autodesk Construction Cloud and shared the connection with serveral users.

We can check the connection and it says that it is 'Online'.

 

According to the documentation this connection should be supported for Fabric Dataflow Gen2;

Autodesk Construction Cloud Power Query Connector - Power Query | Microsoft Learn

But when adding a Dataflow Gen2 and search for Autodesk Construction Cloud, the connection just will not show up. Also not after refreshing serveral times and retries after days.
See screenshot below;

Does anybode else have the same experience?

By the way:

The 'Sign in' is for signing in at Autodesk Construction Cloud, see screenshot below. That should come from the existing connection. That is the whole point of having a centralized Connection to Autodesk Construction Cloud. Or do I see this wrong?
We are in Europe, but I already tried the other 2 regions, just to be sure, the connection might come up there, but no luck!

After logging in with my Autodesk Construction Cloud account, it still does not show the existing connection to select. It does show a sort of placeholder; {"region":"Europe"} (none). See screenshot;

Link to same Post on Microsoft Fabric Community:

Existing Autodesk Construction Cloud connection no... - Microsoft Fabric Community

[lejla.s]

Hi @floris_van_der_zwaard, 

thanks for reaching out to the Data Exchange community - sorry to hear that you are experiencing this issue in your workflow. Unfortunately, we can only provide assistance related to Data Exchange in this forum. 

For help on ACC, please reach out to the ACC General Discussion Forum.

Thanks for your understanding, 

[floris_van_der_zwaard]

Hi @lejla.s , do I need to post the same question there? Or can you move my post to that Forum part?

[lejla.s]

Hi @floris_van_der_zwaard ,

we cannot copy posts between forums, unfortunately. 

However, I tried asking some colleagues, and this is the answer I got, I hope it helps: 

I think there is some confusion on how the connections are setup. The ACC Power BI connector requires a different connection for each server/region (US, EU, AUS) so the existing connection was likely for another region but the new connection the user created called "{"region":"Europe"} (none)" is the new connection they created for the EU server. That connection can only be used to access EU accounts. That seems to be the main concern if I am reading the post correctly. It didn't look like there was any mention of an error or technical issue otherwise. 

Best, Lejla

[floris_van_der_zwaard]

Thank you, for coming back to the issue and asking a colleagues.

In the mean time I had raised a ticket with Microsoft about the issue.
It turns out the documentation is not correct on how this connector can be used.

The workaround is as follows.
After creating the connection as described, you have to create a PowerBi Desktop report, and set up a temporarily connection to Autdesk Construction Cloud in that report. Then publsh that report. This creates a semantic model in the workspace where the report is published.

In the setting of the Semantic model you can change the connection to the shared connection that was created before in the steps as described above.

Then in the same setting enable the option for OneLake ingegration. After a refresh of the semantic model, the semantic model will be available in OneLake. 

On top of that you could create a Lakehouse and create a link in the LakeHouse to the semantic model in the Onelake.