Forum Discussion

oakfootballclub's avatar
oakfootballclub
Icon for Helper IV rankHelper IV
1 year ago

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 ...
Need Help
Show and Tell
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

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.

  • oakfootballclub's avatar
    oakfootballclub
    Icon for Helper IV rankHelper IV
    1 year ago

    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?

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      1 year ago

      Allegedly. You will want to test it.