Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!!!
Solved! Go to Solution.
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
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!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |