SQL connect from Datamart in PBI Desktop Import mode is not pulling the most recent date

The most likely reason why the most recent day's worth of data is not imported when you connect to Power BI Desktop via SQL Endpoint for Datamart in Import mode is that the data has not been refreshed yet. When you connect to a data source in Import mode, Power BI Desktop imports all of the data from the source into the Power BI Desktop file. This can take some time, depending on the size of the data source. If the data has not been refreshed since the most recent day, then that day's data will not be imported.

To fix this, you can try refreshing the data manually. To do this, follow these steps:

1. In Power BI Desktop, select the dataset that you want to refresh.
2. Click the Refresh button.
3. In the Refresh Options dialog box, select the Import option and then click Refresh.

You can also schedule the data to refresh automatically. To do this, follow these steps:

1. In Power BI Desktop, select the dataset that you want to refresh.
2. Click the Data tab.
3. In the Refresh group, click the Schedule Refresh button.
4. In the Schedule Refresh dialog box, configure the refresh schedule and then click OK.

If you are still having problems importing the most recent day's worth of data, you can try the following:

• Check the permissions on the data source to make sure that you have the necessary permissions to read the data.
• Make sure that the data source is accessible from Power BI Desktop.
• Try connecting to the data source in Direct Query mode to see if that works.