Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Experts
I'm accessing the REST API URL as a direct query data source through the CData Power BI Connector for REST but the current URL has a hard coded value but how could I pass parameter dynamically in the power bi.
I have created 2 columns in the schema (JSON) which can be used as a parameter- pease see the below
<input name="effectiveDate" required="true"/>
<input name="prodId" required="true"/>
and change the URL to http://hotsname/sources/DimSales?rs:effectiveDate=[_input.effectiveDate]&rs:prodId=[_input.prodId]&r...
And also created Parameters in the Power BI with the same names (effectiveDate, ProdId) and assigned these to Query dataset in the M Query but got the below error.
Hi @Anonymous ,
Hope these documents can help you:
Parameters for JSON API data - Maintain Query daily;
Dynamic connection to Web URL.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |