fail to refresh dataflow error We couldn't convert to Number

[TNX_Services]

My dataflow is failing to refresh.

Data origen: sharepoint folder (more than one xls with the same structure)

Error message: Error: DataFormat.Error: We couldn't convert to Number. Request ID: a40dce86-0a6c-3a47-2f70-57cb40715d52 Activity ID: 7bea223b-fc31-4183-ad63-1c6844adb076

I changed all column type to "text" and still cant solve the issue.

[v-zhenbw-msft]

Hi @TNX_Services ,

What happens when you connect to this data source with Power BI Desktop?

Please refer this link, hope it helps.

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=59337267-...

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.