Excel not "format as table" at the beginning

[RyanLau]

Hi,

I have run a PowerBI for some years, however, I have not "format as table" of the Excel files initially,

what will happen if I do it (format as table)now, will it break down?

Regards

Ryan

[RyanLau]

Hi @v-rzhou-msft ,

It really helps, many thanks!

Regards

Ryan

[v-rzhou-msft · Accepted solution]

Hi @RyanLau ,

I have a test on myside. Here I get data from a excel sheet and then I create a table on this sheet.

Now we can see the table"Test" and "Sheet5" on Navigator at the same time. And the data we load from the sheet before can refresh successfully. It is still get data from excel sheet.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.