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
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?