Forum Discussion
Real time dashboards
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.
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/
CahabaData I don't think there is definitive documentation out there. I wrote a blog on my understanding based on working with the tool and documentation here which should shed some light on a bit of nomenclature.
It doesn't address cloud specific. So I guess I would say that cloud sources still abide by the same 3 connection types, and that if you are using an API you are just importing data - and as a result of it being a cloud source, it doesn't require a gateway to refresh.
There is a 4th type I suppose, and that would be "live streaming" data from stream analytics or using the live stream tiles.
I believe your case falls into "Import with cloud data source".
My 2 cents.
ah thanks both for clarification ....
