New data from Excel in Power BI

[Anonymous]

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

[Anonymous]

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]

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?