PBi Report behaves different in service than on desktop app

[TERRY_HUGHES]

TDLR: In the desktop app my report will display/slice by blanks but when I publish, blanks breaks the report

Long version: Report has 2 inputs: SQL query and Excel data table. The SQL query is our product information and the Excel is a living document where our ops team writes what we do with product that hit certain criteria. These data inputs are relation-connected via a Product Key. The SQL has all the current items and the PowerBi report/table should show the related Excel notes if there are and blanks if there aren't.

The Report has an imbedded Power App that serves as a write back to the Excel file, so we can use PBi as a workspace.

The table is data from both inputs. On the desktop app (shown above) we can see that the table displays/filters blank Action and Workspace Notes just fine. The imbedded app detects if there are/aren't notes and directs the user to the correct edit form accordingly when they click the EDIT NOTES button.

Note the Action slicer has an actual blank for the filter choice.

When I publish it (to a premium workspace), things behave very differently:

As can see the Action slicer now shows '(Blank)' in leu of a blank, and both the table and app are completly void of all data. If I filter by anything but blank (including 'Select all') I will get data (except blanks):

The Data source credentials are properly set:

There is no incremental refresh set on this dataset, but there are scheduled ones.

So why is this not working in the service but is in the desktop app? I need the service to show the blanks and allow the user to input them into the app to get written back to the file (and then refreshed in at the scheduled times).

[v-cgao-msft]

Hi @TERRY_HUGHES ,

1. I noticed that you are using premium capacity, can you tell me which version of premium capacity you are using?

What is Power BI Premium Gen2? - Power BI | Microsoft Docs

2. If possible, could you try publishing this report to a shared capacity or a PPU capacity workspace and check if it works?

Looking forward to your reply.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data