SQL data synchronization

Hi JoseVictor 

When you use Power BI there are two basic ways to connect to SQL-Database

1) Import mode

2) Direct Query

When you use import mode then you can manually trigger or schedule the refresh of the load, also multple times a day.

When you use Direct Query the data will everytime retrieved from the SQL database when somebody interacts with the report.

BUT in Directy Query you have several restrictions in what you can do. This is why most solutions are built using import mode which is also the recommended practice. If you have very clean data in SQL and less transformation is needed then Direct QUery could be a valid choice. Otherwise you would need to go with import.

Please find below some additional content:

Power BI Get Data: Import vs. DirectQuery vs. Live (2021) - Bing video

DirectQuery in Power BI - Power BI | Microsoft Learn

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.