loading multiple tables

[bisenpiyush]

Hi, I am new to Power Bi. Before I ask my question, there is something you need to know: I have written an SQLite ODBC Driver by leveraging open source.  But in my driver, it only shows data from the views, so it only shows the list of views on "Navigator" page.

Since those are views are not related "Select related tables" works fine. But I have a different issue.

As I investigated, "Load" option tries to create relationship among selected tables but for successful result selected tables should related on the database level, in my case which is not. So if the user selects multiple tables and going for "Load" option. It throws two errors:

1) Load was canceled by an error in loading a previous table - (from Power Bi end)

2) BE_SQLITE_CORRUPT_VTAB from my driver side, which obviously I need to fix 😛 

My question is, Is there any way/option, (similar to Excel "Load To", which works fine for me and I am not getting error 2) which I can set/use so that I can fetch data from multiple tables, and behind the scene, the relationship should not get created. 

For now, as a workaround, I am using "Edit" option. But after that, if I go for "Apply and Close", I get same error 1 

[v-chuncz-msft · Accepted solution]

@bisenpiyush,

You may try deselecting File > Options and settings > Options > CURRENT FILE > Data Load > Relationships.

[bisenpiyush]

It is working fine but not frequently. I still for the same SQLite file I got the error "Load was canceled by an error in loading a previous table "

I click on "Apply change",  then sometimes I fetch the table data successfully and sometimes not.

BTW thanks.