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

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.
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,223,248
Messages
6,171,027
Members
452,374
Latest member
keccles

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