MySQL database with powerBi desktop

hi @mamunxv8,
1. You don't necessarily need to install MySQL Workbench on your desktop to connect Power BI Desktop to MySQL. Power BI Desktop has a built-in connector for MySQL, so you can connect directly using the MySQL connector.

2. You can use incremental refresh for MySQL data.

3. i will recommend using mySQL becasue if you use mongodb then you will have to use the json format for connecting to the datasource because mongodb uses paid connector to powerbi if you use it as datasource. only M10 tiers can connect to powerbi connector in mongodb. else you have to use the dsn connector JDBC to connect to mongo datasource.

If this helped, Please Subscribe AnalyticPulse on YouTube for future updates:
https://www.youtube.com/@AnalyticPulse
https://instagram.com/analytic_pulse
https://analyticpulse.blogspot.com/

Please subscribe CogniJourney On Youtube For fun facts:
https://www.youtube.com/@CogniJourney

Help me grow.