JeffGrant
Well-known Member
- Joined
- Apr 7, 2021
- Messages
- 558
- Office Version
- 365
- Platform
- Windows
HI All, for the past week, I ahve been getting this error when PQ refreshes my tables.
This is my Vvery sinmle quesry.
This query has been running for some two years.
The only think that has happened that I am aware of is a Windows 11 update last week.
Has anybody got a similare experience?
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.
The only think that has happened that I am aware of is a Windows 11 update last week.
Has anybody got a similare experience?