I've been looking for hours but have been unable to find a solution. Basically i need to be able to link a SQL Server Database to act as the source for a Streaming Dataset in PowerBI.
I have been able to create a streamining data and a powershell script using the provided code, but i just don't know to get the dataset to be fed from the SQL server. I'm obviously missing the main part, but very stuck, so any help would be greatly apprecated. Please see details below: