Power BI and Linked to Excel Databases...lost connectivity

[Anonymous]

I have a Power BI dashboard (desktop) that has a table that is linked to an Excel spreadsheet.  Apparently they no longer linked and new updates in the spreadsheet are not appearing in my Power BI dashoard.  Can connections be seen in Power BI and can they be reestablished if they are ever lost?  If not, it will be a major pain to recreate due to the formulas added to the table in Power BI.

[BhaveshPatel · Accepted solution]

Hi There,

To reestablish the connection to the excel file,

Open your PowerBI File,

Go to FILE Tab, Go to Options and Settings , Select Data Source Settings and Select Change DataSource, You can copy your file path here and your are done.

After this is done, check that your connection is ok.

Thanks & Regards,

Bhavesh

[Anonymous]

Excellent...thx Bhavesh!