Solved: Error in dataset refresh

ankit_joshi11 · ‎07-22-2021

Underlying error code: -2147467259
Underlying error message: We couldn't convert to Number.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Detail: customer
Microsoft.Data.Mashup.ValueError.Reason: DataFormat.Error
Cluster URI: WABI-INDIA-CENTRAL-A-PRIMARY-redirect.analysis.windows.net
Activity ID: 82976aa7-5bef-4df0-a2a0-d6beebd31226
Request ID: 990b6827-d6c6-2069-d10c-2b6c34648eba
Time: 2021-07-22 08:44:30Z

selimovd · ‎07-22-2021

@ankit_joshi11

Then maybe the data changed and now you got a value that contains text and can't be converted to a number. Check all of the entries in the data source.

Also in the future add more information, with only an error message it's hard to help you.

Read the following post:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1964858

View solution in original post

selimovd · ‎07-22-2021

@ankit_joshi11

They couldn't convert to Number

ankit_joshi11 · ‎07-22-2021

@selimovd
This error did not show for 1 year. Also checked the power query there is no such problem in the conversion to Number.

selimovd · ‎07-22-2021

@ankit_joshi11

Then maybe the data changed and now you got a value that contains text and can't be converted to a number. Check all of the entries in the data source.

Also in the future add more information, with only an error message it's hard to help you.

Read the following post:

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1964858