Power BI Desktop Data Refresh Issue

Leave a comment

I had an issue recently where the data in my dataset was not making it’s way to the Power BI Desktop report. Basically, there were some records I was looking to see on the report but they weren’t there. I looked at the report filters and could not see anything that would restrict the records. I had added a new column to the dataset, which appeared successfully on the report, but the data just wasn’t refreshing. In fact, Power BI did not try to automatically refresh the data after I had added the field, and when I tried to refresh it myself from the desktop, I would get a timeout error.

After much head scratching, I went to Tools->Options and Settings:

Under Data Load, I selected Clear Cache:

After doing this, I was able to refresh the dataset from the report.

 

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, BI, Web, Cloud and Data Science.

carldesouza.comLinkedIn Twitter | YouTube

 

Leave a Reply

Your email address will not be published. Required fields are marked *