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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors