PQ not refreshing and now gettign this error

JeffGrant

Well-known Member
Joined
Apr 7, 2021
Messages
558
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

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.
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,224,828
Messages
6,181,217
Members
453,024
Latest member
Wingit77

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