Forum Discussion
Solved
Live Stream Power BI
Hi Folks, is it possible to create a Live Streaming Dataset reading Data from a SQL table? I could not find any source which explains it well. I tried to run a PowerShell code to force it ...
Yes, it was an example. Run your SQL query, convert the result to JSON, then use that as the payload.
thanks Ibendlin
so i should convert my sql code which is (Select * from My table) to Json and Run the result inside the windows powershell ISE.
i will search a tool to convert it to json.
thanks a lot
One thing to keep in mind: One of the fields in your table should probably be a timestamp, and it should be in UTC and in ISO8601 format.