Automating SSIS and PowerBI processes

[Matas]

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 to Power BI desktop and building reports that way. I was wondering if there is some automation tools that would allow me not to spend so much time doing manual work, especially when I need to refresh data in the same Dashboard report. Any suggestion are more than welcome! Thanks in advance

Regards,

Matas

[TomMartens]

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