Handling huge database in Power BI_Access Database

[Anonymous]

Dear All,

I use Access Database as my source for Power BI. Currently my database is growing fast, and probably this current file will not be enough to support the amount of data.

As a solution, someone proposed to create a second Access Database file with an identical structure and upload it into Power BI as a continuation of the original file .

Is this solution possible? How do you handle a huge database?

In my opinion it doesn't work, because Power BI runs the coluns in the same database, it's impossible to jump to other database as a continuation. Also considering measures it would be impossible (multiple measures for same card would be a limitation for part of them).

What's your opinion on this?

Thanks in advance.

[freginier]

One or more Power BI will load all your data, it will be very slow.

Maybe can you use Power BI data flow ?