Error refreshing my report - but same source file works fine as excel

[Javier-Fraile]

I am feeding a report in 2 different ways just for testing purposes:

Mode 1 - Excel source as a local file. This one works fine.

Mode 2 - Same excel source in a Teams folder. Using SharePoint source 

= SharePoint.Files("http://......",[ApiVersion = 15])

This mode doesn't work when I hit refresh raising the following error

• Data source errorDataFormat.Error: We couldn't convert to Number.. <ccon>Amount (converted). </ccon>;We couldn't convert to Number.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: ALL_Opportunities.
• Cluster ***************************-redirect.analysis.windows.net
• Activity *****************************************
• Request ***********************************
• Time2023-06-12 09:15:50Z

I don't see how can I identify where the error is, as I don't see anything but the error description added above, which doesn't make sense as the same excel file is working fine in local mode.

Any tips?.

Thanks.

[Javier-Fraile]

Back to same issue ☹️
When I refresh using the Power Bi desktop, it works fine.

When I refresh on https://app.powerbi.com/ it doesn't work raising the following error.

My question is not only if someone has seen this before, but also how to debug the server, because the error doesn't make sense.

ERROR DESCRIPTION
DataFormat.Error: We couldn't convert to Number.. <ccon>Amount (converted). </ccon>;We couldn't convert to Number.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: ALL_Opportunities.

[lbendlin]

Are you connecting to sheets or tables ?

[Javier-Fraile]

Hi Ibendlin,

Thanks for your response.

Let me add that this morning for the first time I could complete the refresh of the excel sheet located on sharepoint successfully.

The transform File states this, so I guess it's a Sheet.

= (Parameter1 as binary) => let
Source = Excel.Workbook(Parameter1, null, true),
#"DSS All Opportunities >2019 SPM_Sheet" = Source{[Item="DSS All Opportunities >2019 SPM",Kind="Sheet"]}[Data]
in
#"DSS All Opportunities >2019 SPM_Sheet"

[lbendlin]

If it is a sheet then it is your responsibility to indicate to Powr Query how to classify each column - after you promoted the headers.

[Javier-Fraile]

Yes, I just led the system promote the columns as the names as well.
Right now I've just refreshed the report for the second time and it ended successfully, I'd say this is resolved.