New column in the data source

[Syndicate_Admin]

Good afternoon.

I'm powering my Power BI dashboard with a folder that contains multiple Excel files. These files all had the same structure, until September 30, 2022 when it was decided to add a new column. Since that day, when the excels I added in the folder contained one more column, the data in these reports is not displayed (I can only see until September 30). Does anyone know what I can do?

Thank you very much for your help!

Marten

[v-easonf-msft]

Hi, @Syndicate_Admin 

As mentioned by @Greg_Deckler ,the table structure in your data source has changed, and the query may report an error. You can found detailed error messages in service gateway.
It is recommended that you edit and modify local PBIX file on PowerBI desktop and then republish it to the service.

Best Regards,
Community Support Team _ Eason

[Greg_Deckler · Accepted solution]

@Syndicate_Admin Sounds like that file is erroring out when importing. You will have to look at your sample file query and determine what is erroring.