Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

PBi Report behaves different in service than on desktop app

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).

Community Support
Community Support



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,

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

Helpful resources

August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community 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.

Top Solution Authors