How to pass parameters to the SQL statement from the embedded app?

[daviidkovacs]

Hi,

I'm new to the PBI services so my question might be a bit silly but I'm a bit lost.

TLDR

Is it possible to pass parameter to the SQL query from the app over the PBI API to display the report? What would be the best way to do that?

Current stack

• In the PBI Desktop we have reports and the SQL queries are sitting there.
• The published reports are in the PBI services in a Workspace.
• We have a single page application with it's own login and role system where we'd like to display the reports.
• We also have an API (in Azure Funtions) what get's all the embedTokens and embedLinks for the reports in a specific group from the PBI services.
• Until this point everything works fine however the report contains everybody's data.
• So I'm wondering would it be possible to pass a param to the SQL query from the app to update the report?

Goal

When the user logs in the app knows the group ID he belongs to. The displayed report should be based on that specific ID and the user should not be able to see any other results.

I imagined something like:

• Somehow passing params to the PBI API:
  https://api.powerbi.com/v1.0/myorg/groups/{groupId}/reports/{reportId}?myId=123

• The report runs the SQL query with the passed param and the embedded report would update.

This might be not the best approach but how could we achieve that? Is it even possible to dynamically update the SQL query from the app/API?

if not, how could I display the data based on the user's role?

Thank you in advance,

Regards

David