Forum Discussion
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 top 12 *
from dbo.EVOL_SO_W10
order by ID desc
union
select top 12 *
from dbo.EVOL_SO_W8
order by ID desc
union
select top 12 *
from dbo.EVOL_SO_W7
order by ID desc
union
select top 12 *
from dbo.EVOL_SO_W2000
order by ID desc
union
select top 12 *
from dbo.EVOL_SO_W2003
order by ID desc
union
select top 12 *
from dbo.EVOL_SO_W2008
order by ID desc
union
select top 12 *
from dbo.EVOL_SO_W2012
order by ID desc
)
select
ID,
[Sistema operativo],
Mes + ' ' + Año [Mes],
Total
from resultado order by ID
When I run this SQL sentence Power BI send me this error
But if I run the same Sentence in SQL Server it works, How can I fix this?
Thanks for the help!!!
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!!
2 Replies
- TomMartensSuper User
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
- TiberwoodRegular Visitor
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!!