Forum Discussion
Confused by whether Power Bi can access live data.
1) In short, yes. The only part I'm not 100% on, is how adding a model layer in PBI Desktop effects these. In my experiance, it removes the live connection and acts like a manual refresh, but I can't say that for sure/for all.
2) Correct, You could connect to you SSAS (Sql Server Analysis Services) Tabular instance. The Power BI AS Connector is the downloaded gateway that you need to install in order to connect to your SSAS instance and have it handle the messaging back and forth from Power BI. (This is the piece that gives you the "live" connection to your model).
Spark on Azure - more here
Anonymous So to clarify and make sure I understand what you are saying... my only options to use Live Data is as follows:
- Using PowerBI Online (what you are calling Service), I would use a connector to Azure SQL DB, Warehouse or Spark. I would then create my dashboards/reports right there online on the web page and let my users look at it.
- Using PowerBI OnPrem (e.g hosted internally at our company), I could connect to SSAS Tabular or Power BI AS Connector (both of these are related to Analysis Server, correct?).
Is this correct?
Also, when you say that I can connect live to Spark, do you mean a Spark instance inside Azure or could it be any Spark instance (say hosted at Amazon or on my website)?
Thank you
1) In short, yes. The only part I'm not 100% on, is how adding a model layer in PBI Desktop effects these. In my experiance, it removes the live connection and acts like a manual refresh, but I can't say that for sure/for all.
2) Correct, You could connect to you SSAS (Sql Server Analysis Services) Tabular instance. The Power BI AS Connector is the downloaded gateway that you need to install in order to connect to your SSAS instance and have it handle the messaging back and forth from Power BI. (This is the piece that gives you the "live" connection to your model).
Spark on Azure - more here