Import from SQL server
Hi! Should it be that after adding new rows in SQL query and importing them either through import mode or direct query in Power BI ID for those new records is again 1 though in SQL query they were counted from 1 to 3?
Hi, I am not sure I understand the question, at the end of the lesson both tables have got matching rows whether they are in import mode or direct query. Can you please provide more details?
Well, in the video after we refreshed data in both our tables (loaded through import mode and direct query) we have three records in both and all information is shown as it is in sql database except ID which equals to 1 for all records.