Power BI Non-null assertion failure when publishing dataset

[moone33]

I see the resolution but my rows returned is ONLY 6 million records.  This is very small dataset compared to other dataset I published. 

The only time I dont get this error is when I remove the Incremental refresh.

[v-cgao-msft]

Hi @moone33 ,

What version of PBI Desktop are you using? What is the base data source? I will try to see if I can reproduce this.

If you are not using the latest version of Desktop, try installing the latest version of Desktop and see if that solves the problem.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

[uzuntasgokberk]

Hello @moone33 ,

There is a detaily mentioned about incremental refresh that you might be missing some areas: https://medium.com/microsoft-power-bi/power-bi-hidden-treasure-incremental-refresh-7e91ac79fc6a

There is a solved issue about non-null assertion failure that might help to you:https://community.fabric.microsoft.com/t5/Desktop/Power-BI-Non-null-assertion-failure/td-p/4160604

Best Regards,
Gökberk Uzuntaş

LinkedIn: https://www.linkedin.com/in/g%C3%B6kberk-uzunta%C5%9F-b43906198/

Medium: https://medium.com/@uzuntasgokberk

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