Execute a query against all the rows of a table in sql

[AmrutaKar]

Hi

I have a table in SQL that stores all my server names. I want to create a server dashboard that gives me realtime results. So i need to run the server queries against all the rows in the SQL table..

For eg  the sql table has

id     serveranme

1      abc

2      def

i need to run  select @@version  against abc and def to get the  sql version and display it in my  Power BI report. How can i achieve this?

Thanks

Amruta

Thanks

[v-frfei-msft]

Hi @AmrutaKar ,

Direct query maybe a work around.

[az38]

Hi @AmrutaKar 

i just want to notice that power BI as any other BI tool is not the good solution for any real-time monitoring from my experience