Skip to main content
cancel
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.

Reply
Analystmate
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.

Analystmate_0-1666789067851.png

Analystmate_0-1668492839643.png

 

 

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'.

6 REPLIES 6
Analystmate
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.

Analystmate
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?

amitchandak
Super User
Super User

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

 

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

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.