Forum Discussion

vissvess's avatar
vissvess
Helper V
6 years ago

Next higher value

Hi Community experts,  I have a scenario where the data is as follows Sequence Actualenddatetime LOS 1 3/12/2020 12:44:01 L2A 2 3/12/2020 12:44:42 L2B 5 3/12/2020 12:45:02 L2A...
vissvess's avatar
vissvess
Helper V
6 years ago

No there is no syntatic error. The same query when executed in SSMS fetches the desired table.
Even when it is loaded to Power BI via import mode, It loads correctly.

 

Only when using direct query, I am getting this error.

 

Please help.!

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Then maybe there are some restrictions on what you can write when in the DQ mode. You should check the documentation.

Best
D
  • TomMartens's avatar
    TomMartens
    Super User
    6 years ago

    Hey vissvess ,

    the creation of temporary objects like temp tables is not supported, the same is also valid for cte's. For this reason you have to rewrite your query like so:

    select
a.*
from
(
SELECT top(100)
*
from
fact.sale
) a

    The subquery a represents your temp-table.

     

    Hopefully, this provides some ideas to tackle your challenge.

     

    Regards,

    Tom