Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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).
@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?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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..
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |