Forum Discussion
Read value from Report URL
- Anonymous7 years ago
HI Anonymous ,
You can use following api to pass query parameters:
Power BI Embedded Query Parameters API
Regards,
Xiaoxin Sheng
Hi v-shex, thanks a lot for your reply.
Parameter list would not work, since those values should come dynamically from the external Web site.
Real life example:
1. The user logs in the website where a Power BI dashboard is embedded in an iFrame.
2. He interacts with the web site, making certain selections, and activates the iFrame.
3. The power BI report must receive those selections via URL, and capture them.
4. Those selections are used to provide values to the HANA input parameters at query level, so these selections can be pushed down to HANA (where the input parameters are used to filter the data at lowest level).
So two questions remain:
1. How to pass parameters from the web to power BI.
2. How to capture those values so they can be passed to the query editor.
I already tried passing filters in the URL, and these can be captured in a measure, but these measure is not visible at query editor level. There is no way to know the active filters in the report at query level.
HI Anonymous ,
You can use following api to pass query parameters:
Power BI Embedded Query Parameters API
Regards,
Xiaoxin Sheng