Forum Discussion

Ivancito112's avatar
Ivancito112
Regular Visitor
1 year ago
Solved

How to avoid LIMIT 1000 validation?

Dear all, How are you?
I comment a little of the context of everything, it happens that approximately ago I was asked to generate some development to reduce consumption (Big Query) in the reports, reviewing I realized that Power BI makes a validation on the data when any type of data load is performed (Transform data and updates), in relation to this researching discovered that if I included the query in a view and called the direct view in Power BI avoided that consumption.
Everything worked perfectly for 3 months, but a couple of days ago (less than a week) started again to do the validation on the same report that 3 months ago worked fine, I did not make any modifications, I did not change my Power BI configuration, or anything like that.
I talk to the BQ administrators and they tell me that my permissions have not changed and there should be no problem with anything.

 

Do you know what I can check to solve this problem?

I remain attentive to your comments.
Have a nice day.

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Ivancito112 ,

     

    According to your statement, I think your requirement is to optmize the Power BI Performance.

    I suggest you to refer to below offical blog to learn more details.

    For reference: Optimization guide for Power BI - Power BI | Microsoft Learn

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Ivancito112 ,

     

    According to your statement, I think your requirement is to optmize the Power BI Performance.

    I suggest you to refer to below offical blog to learn more details.

    For reference: Optimization guide for Power BI - Power BI | Microsoft Learn

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.