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
mhardy
Advocate I
Advocate I

Query Editor will not Refresh

On the main Window, clicking a query called "FieldList" on the data tab shows correctly with all up-to-date data.
- Click Edit Queries
- Click the same query "This preview may be up to 11 days old."
- Click 'Refresh'
- Fiddler shows no request is made back to the server to retrieve updated data
- Yellow dots roll across the top of the screen indefinitely and the data is never refreshed.

- This data comes from a JSON API that via Postman takes less than 200 milliseconds to run

- Close, Edit Queries again.  Click 'Refresh Preview', it comes back instantly but the data is still out-of-date.

 

All other tables depend on this table being correct so it's critical this table is able to refresh in the *Query Editor*.

Outside the Query Editor, it refreshes fine. But inside the Query Editor it's out-of-date and refuses to fresh.

1 ACCEPTED SOLUTION
pqian
Microsoft Employee
Microsoft Employee

@mhardy can you try dumping the cache in Options -> Data Load -> Clear Cache?

 

(ps, what's the cache size before you clear it?)

View solution in original post

2 REPLIES 2
pqian
Microsoft Employee
Microsoft Employee

@mhardy can you try dumping the cache in Options -> Data Load -> Clear Cache?

 

(ps, what's the cache size before you clear it?)

used: 71.4 MB

max: 4,096 MB

 

That did the trick.  Cleared the cache and Refresh Preview pulled in the new data instantly.

 

Thanks,

Mike

 

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.

Top Solution Authors