Forum Discussion
Data Caching in PBI Service
Hi there
Just wondering if anyone has had the same issue with the below and if there's something that can be done to stop it happening again
I have a report published to the PBI service. It has a daily scheduled refresh which has always shown no issues. However it came to light that the information in the table is now showing wrong addresses against job references.
All I did to rectify was open the PBIX file, refresh the data, create a new table, adding in exactly the same info and filters etc, put them side by side and the new tables was showing the correct infomation. All this is coming from one dataset
My questions are
Has this happened to anyone else
How did you capture the issue
How did you ensure it never happened again. Is there some config in the tenant setting or in the capacity setting I need to do
Any help would be really appreciated as im a bit baffled as to why this happened
Many thanks
Karen
3 Replies
Hi there
Just following on ive cleared the Cache in Gloal settings but we were no where near our max
Thanks Karen
Thanks for reaching out to us.
>>However it came to light that the information in the table is now showing wrong addresses against job references.
what's the datasource? and what's the connection mode?
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Hi there's
Thanks for getting back to me.
Data Source is SQL and its Import Mode. All coming from the one dataset. Run the Dataset in SQL and it shows the correct data. Re-add the table in the PBI dashboard and all info is correct but the original table showed incorrect info. Really weird!
Hopefully thats what you meant 🙂
Kind regards
Karen
