Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Lee5150
Frequent Visitor

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 refreshes PERFECTLY in the desktop version, but it will not pull through the same results in the cloud. It's very odd. No matter what I try, it seems to be pulling through information from last week. 

 

Can anyone help?

 

Kind Regards

6 REPLIES 6
Lee5150
Frequent Visitor

Hi all, apologies I've not replied to anyone, I've been on vacation. 

I really don't want this thread to go dead, because it's still an issue for me.

 

An update on this is that I can refresh the dataset in PBI desktop and get the perfect results. I can then publish this to the service and those correct results are mirrored. Great! I then refresh the dataset in the service (after making no changes to the sources) and get the same, incorrect, results I've been getting for weeks. It's very frustrating.

 

My query essentially reads a table in an excel spreadsheet that is updated every week. It then determines which entries are existing, which are new, which have changed etc. I then have a custom column which states whether each row is to be 'deleted', 'updated' or 'created'. Power Automate then uses this column to determine whether it is to add, update or remove entries from a sharepoint list. Quite simple really. I just can't see why it's causing an issue in the service. It's like its holding old data instead of pulling the new data down, whereas the desktop version works as it should.

 

Thank you all

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

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!

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?

sulleyinoz
Advocate II
Advocate II

This might be related to this issue reported a couple of days ago if it used to refresh and has now stopped with no changes. Microsoft is aware and ticket(s) raised.

 

https://community.fabric.microsoft.com/t5/Service/Power-BI-Service-Dataset-Refresh-Error-Expression-...

sergej_og
Post Prodigy
Post Prodigy

Pls provide more information to this.

What result do you see in Desktop, e.g. max date?
What result is shown in Service after update, e.g. max date?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors