Forum Discussion
Import DATA with index or without index
I'm loading data in a .pbix from Oracle to work in an import mode with a Pro Licence.
Are there any differences between load the physical tables with index or the tables without index?
Hi beiker10 ,
That will be fine if your filter the foreign keys out before you load the data. Also you can insert index column in power query to get a new one.
3 Replies
Hi beiker10 ,
If you use the index column to create relationship between tables or you add some calculated columns or measures based on the inedex column . Then you will get errors and you'd better import the whole table tegether with the index column as well. If not, then it should be ok.
I always load the whole table, but the question is:
if i have foreign keys in the tables and some index is faster the load? I understand that I load the whole table with a select * from table, the foreign keys and the index don't have impacts into the performance.
Hi beiker10 ,
That will be fine if your filter the foreign keys out before you load the data. Also you can insert index column in power query to get a new one.
