Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Parameter in PowerBI Embedded

Hello community,


I intend to use Power BI Embedded to display a report from the customer's application.
This report contains telemetry data to an IoT device. The application should be able to select via a frontend filter for which specific IoT device he wants this report to be displayed.
We use a ComosDB or Azure Time Series Insights as data sources for the telemetry data of the devices.
What we should avoid in any case is that we keep all telemetry data for all devices in the Power BI dataset, since the number of IoT devices becomes very large. Much more we would like to retrieve the data for only one IoT device ad-hoc at a report call from the data source.
At first we thought that query parameters would be the solution. However, we quickly noticed that the query parameters are bound to the DataSet and therefore several users cannot call a report for a different device at the same time.
Our next idea was a mixture of a filter and the row-level security in Power BI. Unfortunately, the ComosDB Connector does not support Direct Query. Thus the filter set in advance is of no use to us and you still need all data in the dataset.


Do you know a solution how we can implement our UseCase in PowerBI?


Is it a solution to write a connector yourself?
https://github.com/Microsoft/DataConnectors


I also read the following in the PowerBI announcements today:
https://docs.microsoft.com/en-us/business-applications-release-notes/April19/business-intelligence/power-bi-embedded/dataset-sharing-dynamic-binding
"Dynamic binding will allow developers to define the connection between a report and a dataset programmatically, using the embed token. These capabilities will enable ISVs to use a single report for multiple customers, while binding it in real time to the relevant data for each user, ensuring the security of their customers' data."
Can this statement be used to implement my UseCase or does it mean something else?


Many thanks in advance!
Christopher

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi v-cherch-msft 

       

      thanks for your answer, but why is this a topic for the Dynamics community? A problem is only about PowerBI in connection with a ComosDB or Azure Time Series Insights.

       

      Is my use case in PowerBI possible or not?

       

      Thanks a lot!