cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

PowerBI Dashbords with querystring filters?

I am a developer and  with good bakground on Azure IoT, I read an article about how to integrate Stream Analytics with Power BI to show real time charts coming from an IoT Device..

 

The tutorial is easy and works as a charm.}

 

However I have the following scenario:

We have temperature sensors in our customers, and we have a custom application with a custom developed dashboard, the  dashboard shows the last temperature for each device the clients have, so one customer can have 5 refrigerators, anther one 4 refrigerators. And when they log in , they see the dashboard only with their refrigerators.

 

I would like to do the same I did with custom code but with powerbi, so is there a way I can embed a POWERBI dashboard into each users dashboard, and to send the CURRENT USER as a parameter to the dashboard so that the dashbord only shows their info?

4 REPLIES 4
Microsoft
Microsoft

@levalencia

AFAIK, it is not possible right now. There's no Row Level Security(RLS) for the steaming analytics dataset. You can vote up this idea RLS for Stream Analytics dataset.

 

As a workaround, is a tile showing data of  a dataset in DirectQuery mode acceptable? You can save the sensors data in  azure sql database and set proper RLS in Power BI service. The tile would always show data up to date.

 

Is this possible today with Azure Cosmos DB/Blob Storage?

Thank you, but how can I embed the dashboard into my app and pass parameters to it ? like logged in user for example

@levalencia

Why parameters? Have your read  Row Level Security(RLS)?

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.