Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
WBADAM03
Frequent Visitor

PowerBi Dashboard shows different values from Desktop

Edit:

Something is breaking with my measures. The measures work in powerbi desktop but break when I publish it to the online dashboard for some reason.

There is a measure to calculate a last completed milestone that was passed:

Last Completed Milestone = calculate(DISTINCTCOUNT('Sharepointsite - milestones'[MilestoneName]),'Sharepointsite - milestones'[Result] = "True")

then a measure to find the next milestone: 

Current Milestone = LOOKUPVALUE('Sharepointsite - milestoneorder'[MilestoneName],'Sharepointsite - milestoneorder'[MilestoneOrder],'Sharepointsite - personal'[Last Completed Milestone], " Applied to Graduation")

When in the desktop app, the measures work and as a result, the data card that has a value of last Current Milestone returns something like Proposal Defense.

When I publish it, the last completed milestone measure returns 0 values for everyone and this makes the current milestone return the condition of "Applied to Graduation"

Any ideas why the first measure won't work in powerbi service?

Any advice is appreciated.



Good morning all,



I'm a bit stumped on an unusual problem. I made a dashboard on powerbi desktop that has row level security and a data card that shows a value.

The desktop version has a slicer for a particular person and once selected, all data cards will display the top-most value (last) of a particular milestone of this person. The milestone is looked up by a sharepoint list that assigns a numerical value to a string, so the datacard can determine what the last milestone was.

This desktop version is saved, and then was published to a workspace. The online dashboard is auto-refreshed 5 times a day.

I am 100% sure that this desktop version is the one that got published to a workspace.

Additionally, the dashboard worked for months with no issues.

However, about two weeks ago, I started having problems with the online dashboard.

1: The milestone value, which depends on a record in sharepoint and changes by each person, is wrong in the online dashboard. For example, in the local desktop version, I will have something like "John Smith" in a slicer, when clicked, it will show something like "Milestone 2" in a datacard. In the desktop version, this works flawlessly. In the online dashboard, it will get a random value and assign it to all people.

For example, I have "John Smith" on "Milestone 2" and "Bob Testdude" who is on "Milestone 4". In the desktop version, I will get John Smith selected and correctly see Milestone 2. If I select Bob Testdude, I will correctly see Milestone 4.

On the online dashboard, both Bob and John have a datacard that shows "Milestone 4". 

Additionally, my row level security no longer works on the dashboard for some reason.

I 100% know the desktop version is what is published, and I even republished the desktop version and replaced the old dashboard.

I'm at a loss why the desktop version and the online version have different behavior like this.

Any assistance is appreciated.

1 ACCEPTED SOLUTION
WBADAM03
Frequent Visitor

We solve this:

In sharepoint we made the column originally with a column name of "Outcome" but it was renamed to "Result" at some point.

In powerbi desktop, we have the code "Last Completed Milestone = calculate(DISTINCTCOUNT('Sharepointsite - milestones'[MilestoneName]),'Sharepointsite - milestones'[Result] = "True")".

We made a connection to sharepoint using implementation 1.0 and it worked, but it also showed the column as "Result" and not the internal name of "Outcome". 

When we published to powerBI service, it was using (what we guess) to be implementation 2.0 and it load the sharepoint site with the same colum being named "Outcome" and not the display name of "Result".

Because of this, the first measure would not be able to evaluate the logic and would result in no values. Because of this dependent measure returning no values, the next measure would return the else condition.

We solved this by just changing implementation to 2.0 (Was a bit of a pain) in powerbi desktop and rewriting the first measure to use the "Outcome" column. This solved the problem.

View solution in original post

3 REPLIES 3
WBADAM03
Frequent Visitor

We solve this:

In sharepoint we made the column originally with a column name of "Outcome" but it was renamed to "Result" at some point.

In powerbi desktop, we have the code "Last Completed Milestone = calculate(DISTINCTCOUNT('Sharepointsite - milestones'[MilestoneName]),'Sharepointsite - milestones'[Result] = "True")".

We made a connection to sharepoint using implementation 1.0 and it worked, but it also showed the column as "Result" and not the internal name of "Outcome". 

When we published to powerBI service, it was using (what we guess) to be implementation 2.0 and it load the sharepoint site with the same colum being named "Outcome" and not the display name of "Result".

Because of this, the first measure would not be able to evaluate the logic and would result in no values. Because of this dependent measure returning no values, the next measure would return the else condition.

We solved this by just changing implementation to 2.0 (Was a bit of a pain) in powerbi desktop and rewriting the first measure to use the "Outcome" column. This solved the problem.

WBADAM03
Frequent Visitor

Here I will show this:

 When I press "publish" on the desktop version, while the online dashboard is still loading, it will show the right stuff in the online dashboard until the "refresh" finishes:

WBADAM03_0-1687274949962.png

The student last completed milestone 4, and the next milestone is the proposal defense (a numerical value of 5). This is what the dashboard should show.


This is perfect! 

When I view the dataset for the tracker while it is still refreshing, it will show everything perfectly.

However, when it finally refreshed all the way (no more spinning circles):

WBADAM03_1-1687275112015.png


The same student selected no shows no records for them and it just gives it the default last milestone.

Why?

I even refreshed the visuals. I cleared my cache in my browser. Tried another browser. It just seems to lose the relationship between the 3 tables somehow in the online dashboard.

Why does my dashboard work on my desktop version, and fine when it is refreshing, but after a refresh, it will just "lose" data?



WBADAM03
Frequent Visitor

Additionally, 

When I republish the desktop version and while the online dataset is refreshing, if I open the dashboard it will show the right values for the milestones. 

However, once the refresh fully completes, the wrong values for the milestones show up. 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.