Web Power BI Refresh Failed

[Ray_Jeong1]

Hello.

I'm a Korean and I use a translator, so the sentence may not be a bit smooth.

I will explain in writing because the image cannot be uploaded due to the company's security policy.

Multiple xlsx files are being imported from the polder in Sharepoint.

The contents of the xlsx file have the same type of data, but some files have 'Name', 'Data', 'Item',' Kind', 'Hidden' 5 columns and others have 'Name', 'Data' 2 columns for unknown reasons when imported into Excel.Workbook function.

Desktop can refresh all files if you import the original from a file conversion query, but uploading it to the Power BI Web will result in an error and cannot be refreshed.

--Sheet0 = 원본{[Name="Sheet0"]}[Data]

only have files with five columns, they can be refreshed normally

--Sheet0 = 원본{[Item="Sheet0", Kind="Sheet"]}[Data]

If you do it as above, you can refresh it on the web.

1. Why are files created in the same way stored in different forms?

2. Why does Web Power BI fail to reload when set to Name="Sheet0"?

Please help me with two items.

[Ray_Jeong1]

I am able to attach the image, so I share the capture.

Queries that convert sample files.

File of the first type

File of the second type

Because both types of files have 'Name' columns, when you import a sample file using the code [Name="Sheet0"], Desktop had no problem with the reload, but Web failed.

[lbendlin]

That is just for a single file. Where are you combining the results?

[lbendlin]

Can you show a sanitized version of the Power Query code?