Forum Discussion
real time data refresh use excel
hi experts, I want to create a dashboard in power bi that required to be able to refresh data in real time, and the data the pbix file using is come from excel, for example, whenever I create undate ...
Define what you mean by "real time" ? If once an hour is enough then place the Excel file in a SharePoint Document library and use the SharePoint Folder connector.
Thank you Ibendlin, so if I create a excel in Sharepoint and make it as data source to power bi the requirement would be fultilled?
Allegedly. You will want to test it.
