SQLite BigInt to Binary

[Anonymous]

Hi,

I have following table in SQLite:

but when I use this in ODBC data sources for Power BI, Power BI converts it to Binary type and it doesn't let me load the data.

How can I resolve this issue?

[v-xiaoyan-msft]

Hi @Anonymous ,

When you load data into Power BI Desktop, it will attempt to convert the data type of the source column into a data type that better supports more efficient storage, calculations, and data visualization.

The Binary data type can be used to represent any other data with a binary format. Inside the Power Query Editor, you can use it when loading binary files if you convert it to other data types before loading it to the Power BI model.

For more information, please see: Data types in Power BI Desktop - Binary data type 

Hope it helps,

Community Support Team _ Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

The main issue is this binary type is not letting me import data into model and it cancels the moment click on the Load. So i changed it to text in SQLite db file and everything was fine, table loads perfectly but not with Binary and I had to change every table because of that. Is there a more efficient way to do that or escape that?

[v-xiaoyan-msft · Accepted solution]

Hi @Anonymous ,

I'm sorry that Binary columns aren't supported in the Power BI data model. 

You can only convert the binary file in the data source before importing it into Power BI.
Or you can refer to the solution of this case , which mentions some additional methods.

Hope it helps,

Community Support Team _ Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.