Power BI - Real-time Streaming Data with SQL Server

Question

How can we stream data from SQL server to create real dashboards?

Answer 1

Add the following SQL query

CREATE VIEW dbo.VW_RealTimeDataStreamExample

AS

SELECT d.CustKey, f.DateKey, f.ProductKey, f.DateOfSale, f.Quantity, f.Cost, d.UpdateDate AS CustomerUpdateDate,

F.UpdateDate as FactUpdateDate, d.Name

FROM [fact].[RealTimedatatestingDE]f

INNER JOIN[dim].[RealTimedatatestingcustomerDE] d ON f.CustKey = d.CustKey

and go to Power Bi services and choose a streaming dataset

Want to learn more about Power BI? Check out today: Power BI course