Forum Discussion

MbProg's avatar
MbProg
Helper II
9 years ago

Real time dashboards

I have some dashboards that show the statitic data of some customers, their invoices... We can use Power BI REST API to push data to Power BI Service and show it in dashboards. It works great if you...
Need Help
Tips and Tricks
Tutorial Requests
ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

MbProg Not possible currently but you should vote for this idea here. 

  • MbProg's avatar
    MbProg
    Helper II
    9 years ago

    ankitpatira

    In this article it says that Power BI has Live Connection to those sources (for example SQL SERVER). How is it about those? When a record in a table in the SQL SERVER database changes (is updated), does it update in Power BI too? Or does it delete the whole table and imports the whole table? Or does it just import the new records?

    • ankitpatira's avatar
      ankitpatira
      Community Champion
      9 years ago

      MbProg Live connection to sources is a feature called DirectQuery in power bi. Using that mechanism no data is imported in power bi service. So you need to install and configure power bi gateway on your on-premise server and each time you interact with visuals in power bi service a query gets generated and is sent back to be executed on on-premise data source and results returned back. With DirectQuery there is no import of tables and data.

      • CahabaData's avatar
        CahabaData
        Memorable Member
        9 years ago

        I'm misunderstanding the terminology/definition:

         

        Direct Query requires a Gateway and is involved with On Premise data sources

         

        While I thought that 'Live Connection' was for PBI Service to a cloud data source that did not involve any Gateway....

         

        wrong?