SharePoint Report is blank after service refresh but works fine in the desktop

[WorkHard]

I see this issue reported multiple times on the forum and it's happening to one of my reports.

It's a simple one-page, one datasource (SharePoint list (cloud)).

It works fine in the .pbix I originally created it and refreshes fine but in the service, on next refresh, data disappears.

I believe it can be caused by an incosistency between the service and powerbi desktop Power Query.

Here's the set of operations in Power Query I do on this report. Is there anything here that could cause this:

let
    Source = SharePoint.Tables("https://mysite.sharepoint.com/sites/my-site", [Implementation="2.0", ViewMode="All"]),
    #"longredactedstring" = Source{[Id="redactedid"]}[Items],
    #"Expanded PersonField" = Table.ExpandTableColumn(#"longredactedstring", "Person Field", {"value"}, {"Person Field.value"}),
    #"Expanded Assigned To" = Table.ExpandTableColumn(#"Expanded Person Field", "Assigned To", {"value"}, {"Assigned To.value"}),
    #"Expanded Project PM" = Table.ExpandTableColumn(#"Expanded Assigned To", "Project PM", {"value"}, {"Project PM.value"}),
    #"Expanded Created By" = Table.ExpandListColumn(#"Expanded Project PM", "Created By"),
    #"Expanded Created By1" = Table.ExpandRecordColumn(#"Expanded Created By", "Created By", {"title"}, {"Created By.title"}),
    #"Expanded Modified By" = Table.ExpandListColumn(#"Expanded Created By1", "Modified By"),
    #"Expanded Modified By1" = Table.ExpandRecordColumn(#"Expanded Modified By", "Modified By", {"title"}, {"Modified By.title"})
in
    #"Expanded Modified By1"

[WorkHard]

Does anyone have any suggestions?

[AnkitKukreja]

Hi! @WorkHard 

Can you test this in a new report and maybe in another workspace? Also, test this in Dataflow and try connecting that dataflow to Desktop.

If you can repro this then I would advise you to raise an MS support ticket.