Forum Discussion
Solved
Problem with a Sentence
Hello people this is my first post, i hope to get the answer for my question. I have this SQL sentence: with resultado as (select top 12 * from dbo.EVOL_SO_WXP order by ID desc union select...
Thanks for your help but I solve it, the solution was don't do that in DirectQuery mode, in Import mode I execute the Store Procedure and it works!!
Hey,
have a look here
https://community.powerbi.com/t5/Desktop/Custom-query-with-CTE-not-supported-bug/m-p/80522
,currently the usage of CTE is not supported Power BI
Two ways to circumvent this "limitation
- create views in SQL Server and use these in Power BI
- use Power Query to rebuild the logic of your CTE
My recommendation: 1.
Regards
Tom
Thanks for your help but I solve it, the solution was don't do that in DirectQuery mode, in Import mode I execute the Store Procedure and it works!!