Forum Discussion
Power query loads but errors on close and apply
Hi Anonymous ,
Power BI Desktop has issues on parsing Queries in Direct Query mode that the dataset is treated as a derived table and is illegal in the context of direct query so that statements like DECLARE, CTE will cause syntax error.
Please refer to similar threads below:
https://community.powerbi.com/t5/Desktop/Custom-query-with-CTE-not-supported-bug/m-p/41395#U41395
https://community.powerbi.com/t5/Desktop/Why-is-DECLARE-not-supported-Error/m-p/40983#U40983
https://community.powerbi.com/t5/Desktop/Query-with-CTE-gives-error/td-p/22470
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Power BI Desktop has issues on parsing Queries in Direct Query mode that the dataset is treated as a derived table and is illegal in the context of direct query so that statements like DECLARE, CTE will cause syntax error.
Please refer to similar threads below:
https://community.powerbi.com/t5/Desktop/Custom-query-with-CTE-not-supported-bug/m-p/41395#U41395
https://community.powerbi.com/t5/Desktop/Why-is-DECLARE-not-supported-Error/m-p/40983#U40983
https://community.powerbi.com/t5/Desktop/Query-with-CTE-gives-error/td-p/22470
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.