topic Re: Error refreshing my report - but same source file works fine as excel in Report Server

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

Javier-Fraile — Mon, 12 Jun 2023 15:46:32 GMT

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.

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

lbendlin — Sun, 18 Jun 2023 23:06:53 GMT

Are you connecting to sheets or tables ?

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

Javier-Fraile — Mon, 19 Jun 2023 08:27:56 GMT

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"

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

lbendlin — Mon, 19 Jun 2023 14:47:14 GMT

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.

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

Javier-Fraile — Mon, 19 Jun 2023 16:40:48 GMT

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.

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

Javier-Fraile — Thu, 22 Jun 2023 07:34:03 GMT

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.