I recently made alterations to my data factory data source for Power BI (adding some historical data) and on some of the tables in my Power BI file, data that is older than a week is not being downloaded to the file when I hit refresh.
I have a second Power BI which I used to look at the number of rows in the tables and this file has imported the full revised dataset without a problem. The data queries are the same, the connection is the same, the authentication credentials are the same, and everything is even refreshing properly on some tables in this first file, but for other tables, it is not refreshing to pull old items (though it will still pull new items).
I was able to resolve this on one table by copying and pasting the exact same Source statement in the advanced editor, which seemed to give it the kick to go out and pull the whole data set, but this is obviously not a desirable requirement.
I've tried hitting refresh multiple times as well as redownloading power BI desktop and rebooting my machine.
I'm using the most recent version of desktop Power BI.
