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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Helper II
Helper II

ERROR [HY000] [Splunk][ODBC] (10001) General error: Failed to convert '00771c19-905e-00' to a number

Hi All,


I am loading data in power bi from Splunk using ODBC Connector.


I getting the below error while refreshing data. (Failed to convert '00771c19-905e-0000-9c0d-744b12b2ca47' to a number as required for column 'Account_ID). Whereas the Account_ID field data type is already text.





OLE DB or ODBC error: [DataSource.Error] ODBC: ERROR [HY000] [Splunk][ODBC] (10001) General error: Failed to convert '00771c19-905e-0000-9c0d-744b12b2ca47' to a number as required for column 'Account_ID'.

Helper II
Helper II

Hi All,

This issue is still not resolved, I would appreciate it if you could assist us.

Here is simple work around that worked fine for me in this case. 

I just added a single quote to the column in Splunk Report and able to extract properly in PowerBI. 

Either add quote or some charater 'ACC' to the column in Splunk, extract data in Power BI and then handle the extra char in Power BI.

Helper II
Helper II

@amitchandak Thanks, But this error is not covered in the tutorials you shared. 

@Analystmate , Can you check and confirm that the data type of Account_id is number at source. seems like it is getting a UUID type of value. UUID will not be number here

@amitchandak You are right, in my data Account ID field has a value of type UUID. How to deal with UUID type value in Power Query?

Super User
Super User

@Analystmate , Please open power query and check. You should be able to see more details


debug issue

refer how to handle error in power query

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.


Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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