Advise on real-time dashboard

Hi all,

I don’t have experience on real-time dashboarding but the organization I work for has production lines that are used for packaging products. Each finished product conveys over a sensor that weighs each product and decides whether it is between a certain range. Products that exceed the limitations are filtered out and logged to a database.

Now an internal customer needs a dashboard with a live connection to the filtered products in order to monitor this proces. What would you recommend me to do? What kind of connection would suit, and how do I set this up? What are the requirements?

Herebelow some sample data. Would appreciate all help.

tempsnip

Are you able to use a direct query connection? This is probably the best bet if you need this live.

This way you can build up a model in Power BI desktop and then have it refresh inside the online service more easily than any other method.