Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

New data from Excel in Power BI

Hi everyone,

 

I have a question concerning the synchronization of new data in Power BI. I have a Power BI dashboard which is synchronized to an Excel file from a Share Point. Now I would like to add a new sheet in that Excel file and I want the data in that sheet to also be synchronized to Power BI. 

 

Does anyone know which steps I need to take? 

 

Many thanks in advance,

 

Kind regards,

 

Marc ter Smitten

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Marc1234,

     

    You can link multiple sheets from an excel in Power BI. If the report is already deployed, then you have to edit the report again and do the connection established with the excel file and select the sheets that you want.

     

    To link to excel sheets, you can refer the below URL.

    https://docs.microsoft.com/en-us/power-bi/desktop-connect-excel

     

    Hope this information helps you a lot.

     

    Regards,

    Pradeep

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Pauwnrajpp,

       

      Thanks for your quick reply. Indeed that is what I am looking for, the only thing is that the dashboard is linked to an sharepoint file (online), making it a little bit more complicated to figure out. 

       

      Any suggestions?