Forum Discussion

Florisz's avatar
Florisz
Frequent Visitor
1 year ago
Solved

Existing Autodesk Construction Cloud connection not selectable in Dataflow Gen2

I have been struggling for a while and searched the community and the known issues, but can not find if this is my misttake or a bug. known issues: Fabric known issues - Microsoft Fabric | Microsof...
capacities
  • Florisz's avatar
    Florisz
    1 year ago

    With the help of Microsoft support I found out the Autodesk Construction Cloud Connector can NOT be use this way in a Dataflow Gen2.

    If you want to use a shared connection it has to be used in a Semantic Model.

    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 menu 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.

Florisz's avatar
Florisz
Frequent Visitor
1 year ago

Hi  v-saisrao-msft , thank you for you quick answer.

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!😢

Florisz's avatar
Florisz
Frequent Visitor
1 year ago

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;

 

  • v-saisrao-msft's avatar
    v-saisrao-msft
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi Florisz,

    Thanks for the update and screenshots. Since the connection is online and shared but still not appearing in Dataflow Gen2, this seems to be a limitation or unexpected behaviour with how shared connections are handled for Autodesk Construction Cloud.

    I recommend raising a support ticket with Microsoft Fabric, as this might need backend investigation
    How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

    Thank you.