Forum Discussion

spec's avatar
spec
Regular Visitor
7 years ago

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

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.

Need Help

1 Reply

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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.