Pouyan Ebrahimi
Pouyan Ebrahimi

Reputation: 99

After loading a set of data (from a database) into Power BI using IDBC, where the loaded data are saved on my computer/server?

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

Answers (1)

Dreekun
Dreekun

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

Related Questions