Forum Discussion
Power BI Desktop Not updating data form Access query with refresh
Hi,
Power BI Desktop is causing me some serious headaches right now. I have a report pulling data based off of a query in Access that I built. Since I originally built the dashboard I changed the query in Access so the results are now different. When I try to update it in Power BI Desktop or even create an entirely new file to reflect this it is somehow still pulling in the old record set. This makes absolutely no sense to me can someone explain this as I feel like there is no logical reason this should be happening. It gives me no erros message of any kind.
I have already checked that several times. I have even tried to create a totally new PBI file with a connection to the query in the same Access DB.
After getting another colleague to look at it, it seems like the issue may be either be that it is caching the old data or that because the access DB has linked tables the Power BI file has difficulty pulling in updated results from the query. For the time being I believe I will have to either make a new table to store the results and pull the data from there or export flat files to upload into Power BI..
4 Replies
- parry2k
Super User
Anonymous doesn't make sense what you explained? I haven't worked much in access but we can try to troubleshoot:
Can you make sure Power BI connected to correct access (mdb) file in which you updated your query?
I have already checked that several times. I have even tried to create a totally new PBI file with a connection to the query in the same Access DB.
After getting another colleague to look at it, it seems like the issue may be either be that it is caching the old data or that because the access DB has linked tables the Power BI file has difficulty pulling in updated results from the query. For the time being I believe I will have to either make a new table to store the results and pull the data from there or export flat files to upload into Power BI..
I had the same problem today, and I could solve it by erasing PBI Desktop's cache (File, Settings/Options), but you can have the same result simply changing the MS Access file's name (PBI Desktop will recognise it as a different file, bypassing its cache).
go to File > Option and Settings > Options > Data Load >Data Cache Management Options adn click the button [Clear Cache]
Then : Home > Refresh
