Forum Discussion

drodrig7's avatar
drodrig7
Regular Visitor
4 years ago
Solved

Scheduled refreshed does not import all data

I am in a trouble with an report. When I publish report on the PBI Service and refresh it on demand all data is imported from my Oracle table through my gateway and displayed in the report, but when the refresh is scheduled, not all the data is imported, neither all categories are displayed nor last dates, just a portion of whole information. Btw I don't have any boolean value as a filter either...

 

This is normal? What are the differences between on demand and scheduled refresh?

 

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi drodrig7 ,

     

    Did you check the report immediately after the dataset indicated it was refreshed?
    Datasets, reports and dashboards are separate objects and are not all refreshed immediately after the dataset. It is ordered. If the dataset refreshes, it will most likely be 10-15min before the report, then the Dashboard. you can also initiate a refresh in the report after the dataset.
    Regarding this issue, which seems to be a minor design flaw, we recommend that you configure refreshing for different datasets or dataflows at staggered times. During our investigation, we also found some ideas from other users. If the above doesn't work, you can try republishing the Pbix file to the workspace.

     

    Best Regards,
    Community Support Team _ Caitlyn

    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 drodrig7 ,

     

    Did you check the report immediately after the dataset indicated it was refreshed?
    Datasets, reports and dashboards are separate objects and are not all refreshed immediately after the dataset. It is ordered. If the dataset refreshes, it will most likely be 10-15min before the report, then the Dashboard. you can also initiate a refresh in the report after the dataset.
    Regarding this issue, which seems to be a minor design flaw, we recommend that you configure refreshing for different datasets or dataflows at staggered times. During our investigation, we also found some ideas from other users. If the above doesn't work, you can try republishing the Pbix file to the workspace.

     

    Best Regards,
    Community Support Team _ Caitlyn

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