I'm new to the BI business, and I have to do BI for just over 25 million records.
Importing to Power BI is impractical, since the file would be over 1GB and would be impossible to post on the web. So I opted for DirectQuery. It's just that the loading of dashboards on the web is very slow.
I would like to know the best practice for importing large amounts of data into Power Bi. If it is with DirectQuery (it takes a long time to load dashboards and often not loading because of TimeOut), with Analysis Service or another type of import.
Thank you very much.