Tried everything: Query does not refresh

[ammeijs]

Hi all, 

It is like I tried everything. I looked through multiple topics from this community but still haven't found the answer. 

I have three datasets in my query editor. All being updated so I had to refresh the queries to add new data into PowerBI. Now, one of the queries does refresh, the other two do not. Only when I add the Excelfile as a new data source, then the new data will appear. However, I try to avoid this because then I will also loose all my measures.  

I did the following: 

- I looked at the locations of the source, they were right. 

- I cleared my cache(s)

- I checked if the Enable Loading (when you do right-click) was enabled (it was) 

- I restart the program multiple times

So, I am at a lost. Can someone help me? Thanks in advance. 

[dax]

Hi @ammeijs , 

When you click refresh in query editor, you need to make sure you click "refresh all" 

 In addition, you also could try to close the query editor and click the refresh button in tool bar, will it work? Ty the clear the cache or try to re-create the report, or try to use newest version of desktop to see whether it work or not.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mariusz]

Hi @ammeijs 

It's difficult to help with your situation without looking at the file, but you can reference the new table in the old query and switch off the load on the new table

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn