Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Austin Campbell]

?Hi PBI community. I’ve stumbled across something that is causing me to scratch my head in wonder. I’m hoping someone has seen this kind of issue and is capable of providing me support.

I created a master data set in Power BI and use that dataset to drive all my reports. Its great, one dataset gets refreshed multiple times through out the day, and drives about 5 reports. We went through the correct procedures of creating a workspace and ironing out all the wrinkles in the reports and felt confident about publishing the report collection as an App.  Here is where things went sideways.

Once the app was published, some of the visuals no longer work. Here is the below data error that I get:

Couldn’t load the data for this visual
Couldn’t retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: ad869d52-15d2-44f0-b273-1ba08f2ee486
Request ID: 924e9ce6-7015-ee93-cb35-00943f5596f2
Correlation ID: a8195aee-748a-8de9-115e-4d53dc4ec81d
Time: Wed Feb 05 2020 13:52:14 GMT-0500 (Eastern Standard Time)
Service version: 13.0.12161.272
Client version: 2001.3.018
Cluster URI: https://wabi-us-north-central-b-redirect.analysis.windows.net/

This is bizarre, because it works at the workspace level and desktop level. We haven’t configured RLS on this report, so I don’t believe that is the issue. I only mention this as some help threads discuss this as a possible issue.  I think I’ve narrowed down the cause of the issue to a particular DAX expression:
     VARIANCE = SUM(Production[ProdQty]) – SUM(Sales[ShipQty])
     VARIANCE% = SUM(Production[ProdQty])/SUM(Sales[ShipQty])

The visual is a simple table where row headers = [Month] & [DayNumberOfMonth]
Values are = Production[ProdQty], Sales[ShipQty], VARIANCE Measure, VARIANC%

As I said before, this works at the desktop level and the workspace level, but fails when viewed as an App.  Any thoughts or ideas?

Respectfully,

——————————
Austin Campbell
Manufacturing Data Analyst
Mebane NC
9193047886
——————————

[Jan Brooijmans]

Hi Austin,
You probably checked permissions in the App space? Do you have Premium or not?
This could help: https://www.youtube.com/watch?v=n-9e8AtbSsM&vl=en

Best,
JB

——————————
Jan Brooijmans
Consultant
——————————
——————————————-

[Lutz Bendlin]

Any chance SUM(Sales[ShipQty]) is zero in your production dataset?

——————————
Lutz
——————————
——————————————-

[Austin Campbell]

So I was able to resolve the issue by clicking “Reset to default” within the app. Thank you to everyone who provided possible solutions.

——————————
Austin Campbell
Manufacturing Data Analyst
Mebane NC
9193047886
——————————
——————————————-