Restrict 1 million rows in Direct Query

[prakash11440278]

Hi All,

How to restrict the 1million records in direct query method. I am getting below error when i am refreshing the report. I cannot limit the records in query editor because for that step i need to convert it to import method which i dont want. Kindly advice.

[Seek08]

Did you get any solution for this ?

[AbbasG]

@prakash11440278 From where you are pulling the data?? is it from SQL?

[prakash11440278]

@AbbasG  Thanks for your reply.

I am pulling the data from Azure Data Bricks.

[AbbasG]

@prakash11440278 Sorry, I do not have enough experience with the databricks.

[prakash11440278]

Hi All,

Can any body know the solution for this issue? Thanks.