Do power Bi has some limits of reading a Data from mysql database? I am using a query that for a month give me sth like 700.000 rows with no big problems. When I am trying to get period of half year(it is around 4 millions rows) I got error "mysql fatal error encountered during data read". Is this because of my PC hardware and I need for example more RAM to deal with this huge amount of data?
2 Comments
v-yingjlCommunity Support
Status changed:NewtoDoneCurrently MySQL database uses Import mode to connect in Power BI which has some limitations:
Import Mode Limitations in Power BI
- Depends on the imported data size, A lot of consumed memory and disk space
- On your machine (during the implementation),
- On the online/on-prem server (when it published).
- The Power BI file size can’t be bigger than 1 GB.
- You will get an error If the file size is bigger than 1 GB, in this case, you must have the Power BI Premium that allows having 50 GB file size.
- No recent data without a refresh.
Best Regards,
Community Support Team _ Yingjie LiSo the only idea that I have I got this error because my file is going to be bigger then 1 GB.Do you know how many cells in PowerBI is equal to 1 GB? I think I was trying to have sth like 100 mln cells
