March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet 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
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
|
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.
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
6 | |
2 | |
2 | |
2 | |
1 |