I currently have a file structure that operates as follows:
The step from Excel (1) to Excel (2) is required because we have excel templates which also feed off Excel (2), not just PowerBI.
I've noticed that recently the queries in Excel (2) have struggled to refresh when I refresh the whole file and I am frequently getting this error (or a simple version of the same error which is simply DataFormat.Error: [File contains corrupted data]).
Then, for the first time today, I've received the same 'short form' of the error when refreshing the final link into PowerBI. I've noticed that for the refresh of Excel (2):
Due to the number of tables that feed the data, I was seeking some trouble shooting suggestions I could try myself. Worst case senario, I will create dummy data so I can share the file.
Thanks in advance
Could you please provide a dummy sample? I'm afraid it's hard to find something from the error message even on Google.
Though you have an Excel template, I would suggest you use Power BI to connect the source files directly. I think Power BI Desktop is more powerful in data shaping and transformation, something like ETL.
I've just spent quite some time trying to provide a copy of the file but there are quite a number of cross references. It's easier said than done to remove all the confidential data. I had also tried Googling before posting to the forum without success.
Is there a direct Microsoft support option available for troubleshooting errors given I can't find any documentation on this error?
Maybe you can create a support ticket here following the guide below.