Forum Discussion
Automating SSIS and PowerBI processes
Hi guys, I am currently building Reports in a way: getting dataset in CSV format file, uploading in SSIS procceses, shaping data, creating tables in the SQL database, fetching data from database ...
Hey Matas ,
here you will find a solution to refresh a Power BI dataset using SSIS
Solved: Refresh PBI dataset with ssis - Microsoft Power BI Community
You can also use SSIS to call one or more SQL stored procedure(s) that do(es) the SQL Server things.
Building Power BI reports automatically is nor possible.
Hopefully, this provides an idea on how to tackle your challenge.
Regards,
Tom