I have scheduled refresh current enabled on one of my PowerBI models on PowerBi report server.
However, the values do not get updated. The refresh status always shows as completed and no error.
I think the below may be the issue but hoping someone can confirm if it makes sense:
One of my fact tables is appending tables 2017 dataset and 2018 dataset into the 2019 dataset, thereby created one giant fact table with all three years. I then have disabled load on the 2017 and 2018 dataset as I don’t need those refreshed. I think because I have disabled load on these two datasets that flows into the large fact table hence the table doesn’t refresh.
Does this logic make sense?
Also - if data refreshes in PowerBI server, will the data be refreshed on the desktop version if I download from PowerBI server?