Forum Discussion

mwaters4's avatar
mwaters4
Helper I
7 years ago

real time data sql server

I am not sure if this is the correct place for this post or not. If I need to move it, please let me know.   We run service repair shops and have TVs setup that show the status of the repairs (Targ...
Need Help
mwaters4's avatar
mwaters4
Helper I
7 years ago

thanks for the response... 

Are you suggesting that I use Power BI Desktop to open the report and then make it full screen on each TV locally and it will somehow auto refresh?

Im sorry... I am not following what you are suggesting.  Can you please clarify?

 

thanks

Michael

 

henriquesilveir's avatar
henriquesilveir
Resolver IV
7 years ago

mwaters4 you open in full scren into PBI Service, similar like the suggestion of v-yulgu-msft .

 

But the method of connection must be 'Live Query / direct query'

  • mwaters4's avatar
    mwaters4
    Helper I
    7 years ago

    So best I can tell that method will only let me refresh every 15 minutes via the service.

    I need this to refresh more frequently (every 1 minute or so).

     

    So how can I make that happen?

     

    thanks,

    Michael

    • GilbertQ's avatar
      GilbertQ
      Super User
      7 years ago
      Hi there,

      If you want it more frequently then you would need to use a streaming dataset where you push the data from your SQL Server into the streaming dataset.

      The above will allow the dashboards to be updated in real-time, within a second or two of you pushing the data.

      For reporting purposes, this could then be done via DirectQuery or you could have an import model, due to the fact that this is not based on a dashboard being refreshed every minute.
      • mwaters4's avatar
        mwaters4
        Helper I
        7 years ago

        So I guess im back to where I started... 

        Do you have to have a premium license in order to have streaming datasets?

         

        Someone at a Microsoft Technology Center told me that I just had to have a Pro License to make it work, but I still have not been able to find an answer of exactly how to do that.  Do you know if I have to have a Premium license to make that work?  Anyone know of another way to make this work?  Ive seen some comments about possibly some kind of embedded report being able to do this but nothing that explains how.

         

        Also... when I set something up with Direct Query in the service and have the dataset settings to refresh every 15 minutes, should the browser power bi table auto refresh also every 15 minutes or would I have to have a 3rd part plugin to force a browser refresh?

         

        This is so confusing and seems like a type of scenario that would be very prevalent in the business world.  What am I missing? 

         

        thanks for the help!

        Michael