Something odd with model refresh

Hi moloughlin,

Thanks for reaching out to the Microsoft Fabric Forum Community.

This sounds like it could be due to a few things. If you're using incremental refresh on the imported SQL pricing table, it's worth checking whether the date parameters (RangeStart/RangeEnd) are set up correctly and whether query folding is working as expected, if it's not, Power BI might be quietly limiting the data to recent dates. It could also just be a case of cached data in the Power BI Service, especially with the SSAS live connection, so try clearing the cache or manually refreshing visuals to see if that helps. Another thing to look at is any role-based security in SSAS that might be filtering out older records depending on who’s viewing the report. And finally, it’s possible that the root cause is outdated credentials or a misconfigured gateway for the SQL source if the gateway isn't set up properly, the import won’t refresh correctly, which would explain why you only see the full data after refreshing in Desktop.

If this helped, please mark the response as the accepted solution and give it a thumbs-up so others can benefit too.

Best regards,
Prasanna Kumar