technolo_bi's avatar
technolo_bi
Frequent Visitor
4 years ago
Status:
Done

mysql fatal error encountered during data read

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(...
Gateways
Reports
v-yingjl's avatar
v-yingjl
Icon for Community Support rankCommunity Support
4 years ago
Status changed:
New
to
Done

Currently 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 Li

Completed Ideas