Forum Discussion
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...
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?
Direct Query works for
- SQL Server
- Azure SQL Database
- Azure SQL Data Warehouse
- SAP HANA
Not just for On-Premise Databases but also Azure Databases. Only On-Premise databases will need the Gateway.
If you build your data in Azure Database and just edit the row value with code, and the Power BI report can update via Direct Query at anytime with each load/refresh of the browser . (No scheduled refresh)
More documentation:
https://powerbi.microsoft.com/en-us/documentation/powerbi-azure-sql-database-with-direct-connect/