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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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