Pushing data sets with on premises sql database

[Luukv93]

Hello,

I was wondering if an azure sql database is mandatory for streaming data to the power bi service.
In my case where we operate an on-premises sql database, i would like to know if a direct query connection is possible. Appreciate your assistance.

[v-yuezhe-msft · Accepted solution]

@Luukv93,

If you mean streaming dataset in Power BI Service, Azure SQL database is not mandatory.

In Power BI Service, you can query your SQL Server data and send the data to streaming dataset in Power BI Service using PowerShell. There is a similar thread for your reference.

https://community.powerbi.com/t5/Developer/Stream-Dataset-for-local-SQL-Server-Database-Query/td-p/1...


Regards,
Lydia