Link live excel sheet to powerbi dashboard

[sahil_arora313]

Hi

I am a bit new to PowerBI, I need help in linking my Excel Sheet to a live powerBI dashboard. Data is updated regularly in Excel File by multiple users and requirnment is that when data is added in Live Excel Sheet then automatically PowerBI dashboards should be updated. I have tried using Get Data but haven't been successfull. Please assist

[Alexandra07]

If you store your excel file on SharePoint, you can just connect with your Excel and create Power Automate flow which refreshes the dataset when the file is updated (Probably working flow would be: "when an item or file is modified" -> "Refresh a dataset")

[lbendlin]

that might result in an angry 429 from the Power BI service...

[lbendlin]

That is not currently possible.  Best you can get is hourly, but it also requires users to interact with reports.  Not working with dashboards at all.

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41