Forum Discussion

pawlowski6132's avatar
pawlowski6132
Icon for Helper V rankHelper V
2 years ago

Dynamic M Query Parameter with REST API in PowerBI

I understand how to configure Dynamic M Query Parameters with SQL and DirectQueries.    I'd like to do the same with REST API.   I can build parameterized REST API queries in PowerBI but the defa...
Need Help
lg01's avatar
lg01
Icon for Advocate III rankAdvocate III
2 years ago

Have you found a solution to your issue? I am actually having to work through the same scenario and we have not made it work.  

  • pawlowski6132's avatar
    pawlowski6132
    Icon for Helper V rankHelper V
    2 years ago

    No. Not looking good.

    1. By default, the Web Connector ONLY works as IMPORT storage mode. Dynamic M parameter requries Direct Query Mode.

    2. Building a Custom Connector for REST or ODATA is easily possible. However, to include Direct Query option for that Custom Connector is technically feasible, building the required ODBC wrapper is beyond our skillset capability. Requires C++ dev, etc.

    3. Even with successful Custom Connector with Direct Query ability, I believe API Key web.contents config is requried to avoid having to use Personal Gateway. I'm a little unclear here but see this constraint discussed often in this area of Custom Connector - web discussions.