Forum Discussion

Lee5150's avatar
Lee5150
Icon for Helper I rankHelper I
3 years ago

Dataset in service not refreshing properly

Hi all,   I know there are lots of questions regarding this type of issue, but I can't find one that fixes what I'm experiencing. So, I have published a dataset to the cloud service. That dataset ...
Need Help
sergej_og's avatar
sergej_og
Icon for Super User rankSuper User
3 years ago

Hey Lee5150 ,

can you locate what part of your dataset went wrong after refresh in Service?

Meaning, do you see same date range like in desktop? e.g. Max date is same value?

Number of rows still be the same (I guess "no")?

Is there incremental refresh established?

 

Is quite difficult to help having only description something in Service is doing wrong.

 

Regards

Lee5150's avatar
Lee5150
Icon for Helper I rankHelper I
3 years ago

Sorry I'm being quite vague. I don't mean to be. After a bit of investigation it appears the latest data is being pulled through, but it's what PBI is doing with it that's wrong. The desktop version assesses the data correctly and displays what I'd expect. Just one row to be sent to Power Automate.

 

The whole idea behind this dataset is to list only the rows that need amending in SharePoint. These get sent to Power Automate to give Power Automate the least amount of work to do. So it's the assessing of the data that's not correct in the cloud.

 

The cloud displays nearly 500 rows, where I'd only expect one! The one that's displayed in the desktop version.

 

Is there any reason the queries would be handled differently in desktop and service?

 

Thank you!

  • sergej_og's avatar
    sergej_og
    Icon for Super User rankSuper User
    3 years ago

    There is no reason for handling queries differently. But who knows what happens behind the scenes in Service.
    One idea: do you have some filter applied/removed in Service?