Data Caching in PBI Service

[KarenFingerhut]

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

[v-xiaotang]

Hi @KarenFingerhut 

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.

[KarenFingerhut]

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

[KarenFingerhut]

Hi there

Just following on ive cleared the Cache in Gloal settings but we were no where near our max

Thanks Karen