cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KevinSanDiego Frequent Visitor
Frequent Visitor

Data discrepancy between PBI Service and PBI Desktop

Hi,

 

I am fairly new to PBI and have generally found solutions/answers to my issues/questions I've encountered thus far on the community posts -- this has been an amazing resource to help me learn PBI.  So I want to thank everyone who have contributed and thank the ones who will be able to help me with my current issue.

 

I have a report with one value in Desktop (the correct value) and the incorrect value in Service.  Upon initial publishing both values are correct.  After publishing, I added a refresh schedule and then envoked the 'REFRESH NOW' process:

 

Refresh Now.png

The on demand refresh took about 20 minutes, but was completed succesfully:

Refresh history.png

 

The values on the PBI online has now changed.Service-ReprotAll.pngReport from ServiceDesktop-ReportAll.pngReport from Desktop

What I've done so far to trouble-shoot:

1. Verify that the correct data is what the Desktop is showing, but refreshed the desktop report anyways

2. Deleted the report/dataset in PBI service and republished - values were in sync, but after refreshing data was off again

 

Other info:

Data source is D365 for Finance and Operations (via ODATA)

 

Please let me know if there are other information I can provide that would help.

 

Thank you!

 

Kevin

1 ACCEPTED SOLUTION

Accepted Solutions
KevinSanDiego Frequent Visitor
Frequent Visitor

Re: Data discrepancy between PBI Service and PBI Desktop

Update on this issue.  I opened a ticket with support and it is a known issue.  The bug is related to visual filters with Boolean values.  In Power BI Desktop the values are True/False, however when published to Power Bi Service the values were changed to -1/0.  The filtered value was True but in Power BI Service there was not value = True which basically rendered that filter useless.

 

 

Desktop.jpgDesktopServices.jpgServices - converted values to -1/0 but left the 'TRUE' value select. All Boolean data was converted so no values = True

 

Support provided a couple of work arounds:

 

1. Update data in Power BI Desktop to text value then republish

2. In Power BI Services manually select the filters to -1/0 after pubishing.  Note: each time you publish it will be overwritten.

 

PS. Suport was very helpful and responsed withn two hours from when I opened my ticket.

3 REPLIES 3
v-ljerr-msft Super Contributor
Super Contributor

Re: Data discrepancy between PBI Service and PBI Desktop

Hi @KevinSanDiego,

 

How long does the refresh take on Power BI Desktop? Is it also 20 minutes?

 

All I can expect is that there may be some data updates during these refresh durations. Or it turns out to be an issue with Power BI service, in which case you may need to create a support ticket on Power BI Support page to report the issue and for better assistance. Smiley Happy

 

Regards

Highlighted
KevinSanDiego Frequent Visitor
Frequent Visitor

Re: Data discrepancy between PBI Service and PBI Desktop

@v-ljerr-msft yes the desktop takes about 20 minutes as well.  You mentioned that "there may be some data updates during these refresh durations"  if there are data changes does that cause to the refresh to return incomplete/bad data?  It is likely that are data updates, however I do have a schedule run late evening when no one is in the system and the data in PBI service is still off.

 

Thank you for your reponse.  I will open up a ticket with Power BI Support.

 

Warm regards,

 

Kevin

KevinSanDiego Frequent Visitor
Frequent Visitor

Re: Data discrepancy between PBI Service and PBI Desktop

Update on this issue.  I opened a ticket with support and it is a known issue.  The bug is related to visual filters with Boolean values.  In Power BI Desktop the values are True/False, however when published to Power Bi Service the values were changed to -1/0.  The filtered value was True but in Power BI Service there was not value = True which basically rendered that filter useless.

 

 

Desktop.jpgDesktopServices.jpgServices - converted values to -1/0 but left the 'TRUE' value select. All Boolean data was converted so no values = True

 

Support provided a couple of work arounds:

 

1. Update data in Power BI Desktop to text value then republish

2. In Power BI Services manually select the filters to -1/0 after pubishing.  Note: each time you publish it will be overwritten.

 

PS. Suport was very helpful and responsed withn two hours from when I opened my ticket.

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 335 members 3,382 guests
Please welcome our newest community members: