Forum Discussion

Matthias93's avatar
Matthias93
Icon for Helper III rankHelper III
9 years ago

Referenced query not being updated

  HI,   I have a refrenced query that takes a query to a SharePoint list as a starting point. I have disable this reference query for data refresh. However if I now refresh my repo...
Need Help
Matthias93's avatar
Matthias93
Icon for Helper III rankHelper III
9 years ago

I think this scenario is a bit different, but let me explain to you in more detail what I'm doing and what I'm trying to achieve:

 

I disbled the refresh of the referenced query. My idea was to take in raw data from the SharePoint list in query A, then reference to query A in query B where I actually do all of the operations on my data. Since I'm expanding values in my query B, this tends to slow refresh time down by a lot (times 7). For that reason I figured I could disbale the refresh of query B since it takes query A as a starting point. I'm updating query A so query B should automatically follow. (in my reasoning).

 

Regards,

Matt

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Matthias93,

 

Yes, I have noticed that. In the other scenario, they disable refresh of query A (instead of query B in your scenario).

 

Based on my understanding, currently, the "Do not include in refresh" will and applies only to the specific table, no matter if it is referring another table. Or both scenarios could work as expected. So I would suggest you submit your requirement on Power BI Ideas to improve Power BI on this feature. :smileyhappy:

 

Regards