I have a SharePoint/OneDrive folder where every week I upload an excel file containing data in a fixed format. I have made power queries to do some transformations on the excel data and output the transformed data within that excel in a separate sheet. I also need to connect the excel data (before transformation) to Power BI to display graphs.

I want something which automatically detects that a new excel file has been uploaded to SharePoint/OneDrive, run the power queries on the data in the excel, and also create a connection to Power BI and display the graphs.

I tried using Power Automate but it has a limitation that it can’t run power queries automatically on the excel file. PLEASE HELP me with a solution that can automate this process, I have been stuck for a week trying to find a way.

​I have a SharePoint/OneDrive folder where every week I upload an excel file containing data in a fixed format. I have made power queries to do some transformations on the excel data and output the transformed data within that excel in a separate sheet. I also need to connect the excel data (before transformation) to Power BI to display graphs. I want something which automatically detects that a new excel file has been uploaded to SharePoint/OneDrive, run the power queries on the data in the excel, and also create a connection to Power BI and display the graphs. I tried using Power Automate but it has a limitation that it can’t run power queries automatically on the excel file. PLEASE HELP me with a solution that can automate this process, I have been stuck for a week trying to find a way.  Read More

​