Data showing in Power BI Desktop and Report, but disappears when published to App

[Anonymous]

I've a strange situation with one of my reports that works perfectly in the desktop app.  I publish it to the workspace and it continues to work.  I have made it accessible via and App and when I update the App, some of the data is no longer visible.  If I try to then access the report directly it shows the same behaviour.  I've completely deleted the report and dataset to see if something was corrupt, but this also made no difference.  As the Admin RLS shouldn't be an issue (I double checked this regardless).  Any ideas?

[Anonymous]

Thanks for the response.  Digging futher on the filters, I have a calculated column that is being used to filter.  It is a simple calculation with the code below.  On the desktop approximately half the records fall into "Keep".  When published online I can see that they all end up in "Remove" (hence they are not showing).  Any thoughts?

--------------------------------

Service Record Filter = IF([Record Type]="Service" && [Parent_Service__c] = "TRUE", "Keep",

                        IF([Record Type]="Subscription","Keep",

                        IF([Record Type]="Engagement","Keep",

                        "Remove")))

[Pragati11]

HI @Anonymous ,

There might be something with the DAX If-Else here.

Can you try to club the highlighted lines in a single line in your DAX statement with OR (||) statement ?

Let's see if this makes a difference.

Your DAX will be something like this:

Service Record Filter =
IF (
    [Record Type] = "Service"
    && [Parent_Service__c] = "TRUE",
    "Keep",
    IF (
        [Record Type] = "Subscription"
        || [Record Type] = "Engagement",
        "Keep",
        "Remove"
    )
)

[Anonymous]

Thanks for sticking with me on this.  Unfortuatnely no joy with that, although it does help with contunuing the search.  On my desktop I have 36 "Service" records marked to "Keep".  Online all of these are being calculated as "Remove".  

[Anonymous]

@Pragati11  As a further test I published to a different workspace and it is working fine in that environment.  Unless you can think of anything else I might have to remove the report from the app, delete the data set, and start again.

[Pragati11]

Hi @Anonymous ,

The only thing I can think of is some kind of different access on the old workspace or security roles on the dataset on the old workspace.

[Anonymous]

FYI - I've now saved the report into the workspace where it is not working using the original name (e.g"Report") and then immediatly saved it again into the same workspace with a new name (e.g. "Report_1").  "Report" doesn't work, "Report_1" works perfectly.   Time to delete...

[Pragati11]

HI @Anonymous ,

Can you share a screenshot on what all artifacts do you see in this old workspace related to your report? I am curious to understand why there is a difference.

[Anonymous]

[Pragati11]

Hi @Anonymous ,

Doesn't seem to be an issue here. But I would still argue something is wrong on the previous report regarding security roles might be.

You can actauall try raising this with Microsoft to understand what might be wrong here.

[Anonymous]

@Pragati11 I deleted and republished the online report in the workspace and it is working now as expected.  I suspect that there might of been some corruption on the data.  Thank you very much for your input and support.  It is greatly appreciated.

[Anonymous · Accepted solution]

Unfortuantely my success was short-lived.  With further troubleshooting I was able to identify that the True/False columns were being displayed online as 0 and -1 hence the filter did not work.  Fixed the type and formulas and all good now.

[Pragati11]

HI @Anonymous ,

So looks like it was one of your filters issue.

Don't forget to mark my response as a solution if it helped you in any way to troubleshoot & fix the issue at your end. It will just help others on the firum.

[Pragati11]

Hi @Anonymous ,

When you say data is missing, can you make sure there are no filters in your report that are filtering out this missing data?