Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply

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 3
v-xiaotang
Community Support
Community Support

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.

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

Hi there

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

Thanks Karen

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.