Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Javier-Fraile
New Member

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

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

JavierFraile_0-1686584577028.png

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.

 

5 REPLIES 5
Javier-Fraile
New Member

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
Super User
Super User

Are you connecting to sheets or tables ?

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"

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.

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.