Reputation: 99
I used ODBC to connect to a database and loaded a big data (around 20 million rows) into Power BI desktop. Am I only connected to the database or I duplicated the data somewhere in my computer or on the server?
I would love to AVOID duplicating my data. Any guidance is appreciated.
Upvotes: 0
Views: 30
Reputation: 442
If you used Import, the data was loaded into Power BI Analysis Server. If you used Direct Query, it didn't load the data.
Upvotes: 1