sql - Sql 查询在 PgAdmin 中运行，但在 PowerBI 中失败

Question

我正在尝试在 PowerBI 中运行 SQL 查询，但它总是因“EnableFolding 错误”而失败。我尝试了不同的解决方案，例如使 EnableFolding=false 但没有运气！我相信我的查询可以优化，但由于我是编写 SQL 查询的初学者，我需要专家的帮助。这是我的 SQL 查询 -

select sub1.*, sub2.mem2, sub2.cp_attr1 from 
(SELECT sub.customer as mem1, sub.data_attr1, sub.data_attr2 as lic_attr2, sub.timestamp  FROM(
    SELECT  customer,  data_attr1, data_attr2, timestamp,
            max(timestamp) OVER
            (
                PARTITION by customer
                
            ) AS max_timestamp 
    FROM tableA where name = 'P' 
    ) sub 
WHERE sub.timestamp >= max_timestamp - interval '1 hour' ) sub1
join
(SELECT sub.customer as mem2, sub.data_attr1 as cp_attr1, sub.timestamp FROM(
    SELECT  customer,  data_attr1, timestamp,
            max(timestamp) OVER
            (
                PARTITION by customer
                
            ) AS max_timestamp
    FROM tableA where name = 'Q' 
    ) sub 
WHERE sub.timestamp >= max_timestamp - interval '1 hour') sub2
on sub1.mem1 = sub2.mem2 
where REPLACE(sub1.lic_attr2, ' ', '')  like CONCAT(CONCAT('%', REPLACE(REPLACE(sub2.cp_attr1, ' ', ''), '/', '')), '%')

我正在尝试获取每个客户的最新记录以及比最新时间戳早 1 小时的记录。此查询在 PgAdmin 中运行，但不在 PowerBI 中运行。任何帮助，将不胜感激！

标签： sqlpowerbi