Forum Discussion

shardison's avatar
shardison
Regular Visitor
3 years ago

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

When i connect to Power BI desktop via SQL Endpoint for Datamart and use Import mode, the most recent days worth of data does not come over. For example, today is 8/25/2023 and the datmart contains d...
Need Help
Covenant-bi's avatar
Covenant-bi
Icon for Helper I rankHelper I
3 years ago

If you are using a data source that is located on a remote server, you may want to consider using a gateway. A gateway is a server that sits between Power BI Desktop and the data source. The gateway helps to improve the performance of data refreshes by caching the data locally on the gateway.