Forum Discussion
SQLite BigInt to Binary
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.
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?
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.