Forum Discussion

lemieuxreview's avatar
lemieuxreview
New Member
2 months ago
Solved

data exchange use filters and add reference parameters

When importing data using the Autodesk Power BI data exchange I am setting the "use filters and add reference parameters" ]to yes in hopes to select only the necessary parameters from Revit, instead of the hundred or so that pass through if this was set to no. However the filter does not bring up the window where I can select which parameters to bring through. This seems to not be working as intended as I've seen training videos that show when the filter is set to "yes" an additional window comes up where they were ablt to choose specific parameters. Any solutions to this?

  • Hi and thank you for the reply. None of these methods have worked unfortunatly. I will just choose transform data and choose columns in power query.

7 Replies

  • Kagiyama_yutaka's avatar
    Kagiyama_yutaka
    Icon for Continued Contributor rankContinued Contributor

    The param filter in Autodesk’s Power BI Data Exchange only appears when the Revit Data Exchange add‑in and the PBI connector are on the same version and the exchange file is selected in the Navigator, so the practical fix is to update both to the latest version and then reopen and select that exchange before loading

    • lemieuxreview's avatar
      lemieuxreview
      New Member

      Hi and thanks for the reply. The Autodesk Power BI Data Exchange latest version is 1.12.1 and the Revit Data Exchange latest version is 2.4.0, so I'm not sure how these need to be the same version when they are both the latest version. Is there something I'm missing? Do I need to find older versions of the Revit Data exchange to match the version 1.12.1 of the Power BI connector?

  • hey lemieuxreview some suggestions you could explore:

    • Make sure you're using the latest version of the Autodesk Data Exchange Power BI connector/add-in. Older versions may not display the parameter selection dialog.
    • Re-create the connection and set "Use Filters and Add Reference Parameters" = Yes before loading the data.
    • Verify that the selected Data Exchange actually contains reference parameters that can be exposed for filtering.

    If the parameter selection window still doesn't appear, it may be a connector-specific issue.

    I'd recommend checking the connector version and raising a support ticket with Autodesk, including screenshots of the connection setup.

    Appreciate if you can "Kudos" and/or "Accept as Solution" if this answered your query.

    • lemieuxreview's avatar
      lemieuxreview
      New Member

      Hi and thanks for the reply. I followed these steps exactly and I'm still unable to get the filter menu to appear when loadingthe data. The image attached is what I'm presented with when following these steps and replicates the issues that are persistantly happening. 

  • v-csrikanth's avatar
    v-csrikanth
    Icon for Community Support rankCommunity Support

    Hi lemieuxreview 

    Thanks for reaching out to Fabric Community and sharing the screenshot.

    Here are a few suggestions to help troubleshoot the issue:

    • Ensure you're using the latest Autodesk Data Exchange Power BI connector. If you're using a custom connector (.mez/.pqx), replace it in Documents\Power BI Desktop\Custom Connectors and restart Power BI Desktop.
    • Create a new PBIX and connect via Get Data > Autodesk Data Exchange. The "Use filters and add reference parameters" option is only evaluated when the connector is first invoked.
    • Verify File > Options and settings > Options > Security and ensure data extensions are allowed, then restart Power BI Desktop.
    • Test with a different or simple Data Exchange to determine whether the issue is specific to one exchange.


    Based on your screenshot, Power BI detects the Data Exchange, but the expected parameter selection dialog isn't appearing before the Navigator opens. If the issue persists after the above checks, it may be a connector-specific issue. In that case, I'd recommend contacting Autodesk Support and providing your Power BI Desktop version, Autodesk Data Exchange Connector version, Revit Data Exchange version, and a short screen recording of the connection process.

    Thank you,
    Srikanth Cheri
    CST Team.

    • lemieuxreview's avatar
      lemieuxreview
      New Member

      Hi and thank you for the reply. None of these methods have worked unfortunatly. I will just choose transform data and choose columns in power query.

  • v-csrikanth's avatar
    v-csrikanth
    Icon for Community Support rankCommunity Support

    Hi lemieuxreview 
    Thank you for sharing your approach to proceed further on your requirement.
    If you have any other related to Fabric and  Power BI do reach out to community.

    Thanks,
    Srikanth Cheri 
    CST team.