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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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