PQ not refreshing and now gettign this error

JeffGrant

Well-known Member
Joined
Apr 7, 2021
Messages
519
Office Version
  1. 365
Platform
  1. Windows
HI All, for the past week, I ahve been getting this error when PQ refreshes my tables.

This is my Vvery sinmle quesry.

Power Query:
let
    Source = Table.Combine({tblRY12, tblRY22, tblRY32, tblRY42,tblRY52}),
    #"Sorted Rows" = Table.Sort(Source,{{"Date", Order.Ascending}}),
    #"Filtered Rows" = Table.SelectRows(#"Sorted Rows", each
    DateTime.Date([Date]) >= DateTime.Date(Date.AddDays(DateTime.FixedLocalNow(), -45))
),
    #"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"Winnings", type number}}),
    #"Removed Other Columns" = Table.SelectColumns(#"Changed Type",{"Date", "Track", "Race Num", "Winnings"})
in
    #"Removed Other Columns"[CODE=pq]

This query has been running for some two years.

1667122128880.png


The only think that has happened that I am aware of is a Windows 11 update last week.

Has anybody got a similare experience?
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Problem resolved by starting over and re-building the PQ's and Pivot tables. However, this time, I dispersed the placement of the PQ result table and Pivot table into a different areas of the workbook.
 
Upvote 0
Solution

Forum statistics

Threads
1,215,510
Messages
6,125,220
Members
449,215
Latest member
texmansru47

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top