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.
I AM SPENDING MORE TIME THESE DAYS CREATING YOUTUBE VIDEOS TO HELP PEOPLE LEARN THE MICROSOFT POWER PLATFORM.
IF YOU WOULD LIKE TO SEE HOW I BUILD APPS, OR FIND SOMETHING USEFUL READING MY BLOG, I WOULD REALLY APPRECIATE YOU SUBSCRIBING TO MY YOUTUBE CHANNEL.
THANK YOU, AND LET'S KEEP LEARNING TOGETHER.
CARL