Not Showing Post Publish

Question

Hello all, I have a weird one that has me a little stumped. It's a pretty simple formula and that is why I am so confused about why this is happening. I am counting the number of times each agent is using certain dispositions. I have a Microsoft power apps that the agents place a code, that code gets dumped into a SharePoint table and is then accessed by my power bi to count use.

Here is the table

It's line-by-line boolean logic for true or false.

My formula for counting is as follows.

Total 3 Month Hold = calculate(counta('Supplies PIM'[3 Month Hold?]), 'Supplies PIM'[3 Month Hold?] = "True")

Then I have date slicers for timing.

on desktop, it is correct and looks like this.

When I publish to our company app, it looks like this...

There are no changes to the source data, permissions, filters, everything else in the report works just fine but when published, I run into this error.

Any ideas on what I am doing wrong or how to correct it?

anonymous · Answer

Kind of a pain in the butt to do but it worked! thank you!&nbsp;

allisonkennedy · Answer

Anonymous&nbsp; This is a strange one - have you published this report previously? Try changing the name and see if it still gives the same problem, or delete the dataset from Power BI service and republish. If you overwrite a dataset it sometimes can't make all changes unless you delete/start fresh.&nbsp;

allisonkennedy · Answer

You're welcome! Glad it worked.&nbsp;

anonymous · Answer

Hello there, I marked the prior comment as a solution. However, today (after the auto-refresh) it has seemingly reverted to having the same issue again. I would need to manually refresh on the desktop and publish daily to get this to work. I, unfortunately, need to find a solution to this long term.&nbsp;

anonymous · Answer

Nope, it's actually reverted back to the same issue as before. Desktop, it will refresh fine, once published it will error out and show blank on the counts.&nbsp;

Forum Discussion

Not Showing Post Publish

7 Replies

Related content

Publish Report

Chiclet Slicer showing default Tooltips after being published

Delay post publishing report in Service

Reports Published

Published App shows all hidden pages