Excel to Power BI

Question

Hi I have a Power BI dashboard that gets refreshed by an Excel file with multiple sheets in it. I am exploring an option to refresh the same using an Alteryx workflow in such a manner that whenever the flow is given a run command with new excel input, it outputs refreshed Power BI dashboard.

Qiu · Answer

@marora1

I did not try it but this one should help.

you can run the power shell or use Run Command if you want it to be in Alteryx.

https://github.com/Azure-Samples/powerbi-powershell/blob/master/manageRefresh.ps1