Forum Discussion

Tiberwood's avatar
Tiberwood
Regular Visitor
8 years ago
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 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!!!

  • Tiberwood's avatar
    Tiberwood
    8 years ago

    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