Forum Discussion
tinaklo
Microsoft Employee
Microsoft EmployeeKick off data refresh with SQL Agent Job
Hi there, Our setup...we have an enterprise gateway installed on our server to refresh the Power BI dashboard and report. The underlying data sources for the report are tables and views from a SQ...
It is surely possible. Power BI Services provides the APIs to import data into a published report, you can follow this toturial Push data into a Power BI dashboard. Recently I am studying on this, it is quite easily understanding if you have some coding skill. Just form data in JSON format and call the APIs to load data to Power BI services.
Regarding developing, you can create a console application following the tutorial in Visual Studio or SQL Server Integration Service(my preference),and schedule a windows task or SQL Server Agent job to load data in a certain interval automatically.
Also check Power BI REST API limitations.
spaxia
Helper I
Helper IAnother solution can be to have an Azure SQL and replicate Data in the Cloud....