Forum Discussion
How to fill-in parameter dialog (SAP Fiori app)
Dear Community,
I would connect Power BI to SAP Fiori through CDS views (OData.Feed).
In SAP, when I open « Market Segment » app, first a parameter dialog with mandatory fields is shown.
When I fill-in parameters, I have acces to data.
In Power BI I can’t acces to data beacuse, I suppose, first I have to define these parameters.
I’ve tried to use URL?filter=Table/Field eq 'value’, (https://learn.microsoft.com/en-gb/power-bi/collaborate-share/service-url-filters) but it doesn’t work.
Please, do you konw how I could have acces to data in Power BI ?
Thank you.
Hi JoeMel
You can consider to use the api to get the related content from Power BI, You can refer to the followiing link.
Power BI REST API: Step-by-step Guide to Use It | Coupler.io Blog
Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi JoeMel
You can consider to use the api to get the related content from Power BI, You can refer to the followiing link.
Power BI REST API: Step-by-step Guide to Use It | Coupler.io Blog
Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- metrica
Post Prodigy
Hi JoeMel,
The Power BI report URL filter syntax does not pass values to SAP OData. The fields in the Fiori dialog may be either CDS parameters or mandatory OData filters, so check the service $metadata or the request generated by the Fiori app.
For parametrized entities, values must be supplied through the OData parameter path. Regular fields should be passed through $filter.
You may also evaluate Power BI Connector for SAP: https://www.sap.com/products/data-cloud/partners/metrica-software-inc-power-bi-connector-for-sap.html
It detects metadata-defined parameters and supports server-side filters. Saved values are reused during refresh but cannot be changed dynamically by report slicers.
A 30-day free trial is available.
Documentation: https://metricasoftware.com/docs/sap/
Cheers,
Metrica Team
