Data Format Error from ODBC Splunk

[Willas]

I please need some support. I am connecting to a splunk Dataset through a ODBC connector. But I am getting data column formatting issues from my dataset in Splunk. I am not able to amend or fix the data as the dataset is very large. Is there a way to bypass this initial check PowerBI does when I am adding the dataSource?

Thanks so much

Data Format issue

[v-yingjl]

Is there a way to bypass this initial check PowerBI does when I am adding the dataSource?

Actually it is not supported to 'bypass this initial check' by Power BI because only column only allow one data type.

However, if you do not want the 'R00001' value in the column, you can open Power Query Editor to remove or replace this value from the column so that it would not remind the data format error. Or you can convert the whole column to the text type to avoid this.

Best Regards,
Community Support Team _ Yingjie Li

[Willas]

Okay - But with a new refresh from the dataSource will it not then pull in the same value again? Remember we are not amending or fixing the issue at source, we are only then fixing it within PowerBi Desktop and with the new refresh of data, the old issue data will be pulled in again?

Thanks