Large csv can be imported into Power BI by unchecking the background data checkbox in the Power BI settings.
Another option is to import data first into SQL and then use direct query to import data from SQL to Power BI in few seconds. For complete courses, you can buy these courses from Udemy on discount using the following links
https://www.udemy.com/course/ssas-tab...
https://www.udemy.com/course/power-qu...
https://www.udemy.com/course/microsof...
https://www.udemy.com/course/power-bi...
https://www.udemy.com/course/learn-al...
Skillshare users can follow me on Skillshare for all the courses!
https://www.skillshare.com/r/profile/...