cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pwrbiadm
Helper I
Helper I

Report in PBI Service not matching with PBI Desktop

Hello,

 

I am not able to understand why the same report when published to PBI Service is not matching with PBI Desktop. I have tired recreating the same calculated columns in a different table, and even tried deleting the existing dataset and reloading it with a different name. Please see below screenshots and help. 

 

Thanks,

Gaurav

 

PBI DesktopPBI DesktopPBI ServicePBI Service

6 REPLIES 6
DillanB
New Member

I just had the same issue. Mine was caused by having a filter on the page for [Column] = TRUE. It worked perfectly on desktop but on the online version my pages were blank. It turns out that for whatever reason the online service was summing the TRUE/FALSEs (if more than one) and providing a number for the filter to use. Obviously, this number never equaled TRUE so it returned 0 items.  I fixed it by forcing the columns to be Text values and updating my filters from = TRUE to = true and it fixed everything.

v-lili6-msft
Community Support
Community Support

hi, @pwrbiadm 

Do you try to refresh the dataset both in the power bi desktop and power bi service to keep them have the same latest data? 

In power bi Desktop:

You can perform a one-time, manual refresh right in Power BI Desktop by selecting Refresh on the Home ribbon. When you select Refresh here, the data in the file’s model is refreshed with updated data from the original data source. This kind of refresh, entirely from within the Power BI Desktop application itself, is different from manual or scheduled refresh in Power BI, and it’s important to understand the distinction.

3.JPG

 

In power bi service:

You could also refresh dataset manually, and then please refresh the report for the visual cache.

4.JPG

5.JPG

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lin,

 

Yes, I have already tried refreshing both PBI Desktop & Service manually but that wont fix it. 

hi, @pwrbiadm 

If the datasets are the same. Is there RLS setting for this report?

https://docs.microsoft.com/en-us/power-bi/desktop-rls

https://radacad.com/row-level-security-configuration-in-power-bi-desktop

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Lin,

 

Datasets are same and No RLS.

hi, @pwrbiadm 

If you try to download the pbix file from power bi service, and then compare them.

And if the slicers are the same (for example: like this case https://community.powerbi.com/t5/Service/Filters-don-t-refresh-in-Service-even-though-saved-in-Deskt...)

or there are visual/page/report level filter on it?

 

If you still have the issue, you'd better create a support ticket in Power BI Support to get further help.

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors