Power BI report partial data load after Scheduled Refresh on power bi server

[spec]

Hello,
I have 7500 records in my dashboard when I refresh the report in power bi desktop all the records are displayed. After that when I upload the same report to server then also all the records are visible, but as soon as I refresh the dataset on power bi pro I lose some data I only get 7000 records. This happens for both, scheduled refresh and manual refresh of the dataset on power bi pro.

I have checked my gateway and it is up and running, I am using a personal gateway.

[v-xuding-msft]

Hi @spec ,

What kind of data source do you connect? And What mode do you use?  If you could use DirectQuery mode,  you can use it as a workaround. In this way, the size of  dataset is very small. And the data can be refreshed more than 1 million rows.

Best Regards,

Xue Ding

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