Encountered problem starting this October regarding our scheduled refresh. Only have three data sources, which are 2 excel files and one from the MySQL Database. Here is the error, D...
Anonymous
3 years agoNot applicable
Hi bcdejesus ,
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.
You may also refer to Solved: mysql fatal error encountered during data read - Microsoft Power BI Community
Best regards.
Community Support Team_ Caitlyn