Power BI service showing wrong values

[Maradh]

Hi,

I don't know if it's a bug or not but im having a lot of trouble trying to make specific report (with the specific OneDrive update) on Power BI service.

My goal is to show the most recent value by personal Id but i find it to be impossible with what Power BI web service has to offer, here is some screenshots :

In the screenshot above, i display all number of rocks and you can see what each number of rocks has for Date and hour (most recent)

In this one, i display the sum of all number of rocks

This one is the minimum number of rocks

And finally, this screenshot with the max number of rocks but with the wrong Date and hour (most recent) which is the same date/hour as the minimum value

I don't know, maybe Power BI web service has too much restriction, can anyone help ?

[Greg_Deckler]

Most recent value generaly goes something like this:

Measure =
  VAR __ID = MAX([Personal ID])
  VAR __MostRecent = MAXX(FILTER('Table',[Personal ID] = __ID),[Date and hour (most recent)])
RETURN
  MAXX(FILTER('Table',[Personal ID] = __ID && [Date and hour (most recent)] = __MostRecent),[Number of rocks])

[Maradh]

Yeah but the problem is that i can't create measure since i can't work on Power BI desktop for this specific case because i need to use the Onedrive update (the one which is set with only one file in Onedrive business)

So the way i try to get the value i want is through filters or data fields like not resuming, sum, max, min, most recent, etc. But it seems it doesn't work the way it is supposed to.

[v-lionel-msft]

Hi @Maradh ,

This should not be a bug, but a normal summary of the data.

You can use Web connector to connect to OneDrive, then, publish your report to Power BI Service.

For the [most recent], you may need to create a measure to return the date and hour. 

Use OneDrive for Business links in Power BI Desktop 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Maradh]

Im already using the web connector for all my other reports on Desktop to get all my data from OneDrive.

But in my case, i need the specific OneDrive refresh which can only be use with a report on Power BI Web service

[v-lionel-msft]

Hi @Maradh ,

If you use web connector in Power BI Desktop, you still can use OneDrive refresh in Service , the model is as below. In other words, the dataset will refresh when the .xlsx/.csv files are updated.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Maradh]

Hi,

I think i get it but i don't know how to do it

Can you explain a bit more on how we can create that ?