Forum Discussion

Ray_Jeong1's avatar
Ray_Jeong1
New Member
1 year ago

Web Power BI Refresh Failed

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.

3 Replies

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

  • 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's avatar
      lbendlin
      Super User

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