Transformation Alert on DirectQuery

[rekhasagar04]

Hello,

When I select import option, it takes forever to load the data. If I select Direct Query, I have been an alert as "This query contains transformations that can't be used for DirectQuery". Please provide your solution. 

Thanks,

RS

[amitchandak]

Have you converted a import to direct query ?

[amitchandak]

@rekhasagar04 , Are you still facing the issue. if you need more help make me @

Appreciate your Kudos.

[rekhasagar04 · Accepted solution]

I have reimported all the views from SQL Server. This alert got disappeared. 

Thank you all for your response.

Thanks,

RS

[Greg_Deckler]

Very difficult, can you post your code from Advanced Editor? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490