Can I refresh Sharepoint data just by refreshing the report?

[AliceW]

Hi guys,

I don't know if this feature exists, but it would be so cool if it did.

I have one dataset connected only to one OneDrive Excel file. Ideally, the user will enter something in the Excel file then click refresh in the report and see his latest data.

Right now, I'm using a Sharepoint File connection. I need the user to refresh the dataset and then the report.

I'd like to bypass the dataset refresh.

Any advice will be greatly appreciated.

Thanks,

Alice

[nandukrishnavs · Accepted solution]

@AliceW 

You could integrate PowerAutomate(Microsoft Flow) for refreshing the Power BI dataset. 

Refer to this: https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

[AliceW]

Thank you, Nandu. I've implemented it and it works!