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.
I have run into a fairly large issue for using Power BI for reporting. With 30+ API endpoints, without the ability to create multiple query parameters within a URL, I'm unable to use the tool for reporting. For example:
Creating the following source:
Results in the following error:
Is there a workaround for this? If not, this seems like a huge oversight for REST API functionality.
Hi,
1. You need to set parameter for “auth” and “team”. Set both “Type” to “Text”
2. Just add your parameters as URL parts, you don’t need to add string like “auth=”, ”team=”.
3. After click OK, you will be able to get data from the web.
Best Regards
Alex
You need to create a parameter table for passing a dynamic patrameter value to your web queries.
First create a function
(team) =>
let
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 |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |