Bananathan Tracker

Re: Reports in service will not refresh after gateway credential update

Bananathan — Tue, 23 Jul 2024 14:53:29 GMT

For anyone else that comes across this.

Restarting our gateway seems to have solved the issue

Re: Reports in service will not refresh after gateway credential update

Bananathan — Tue, 23 Jul 2024 10:34:01 GMT

Got a new error message - though just looks like a timeout:

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Downstream service call failed with status code '403'."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Error","detail":{"type":1,"value":"Access token has expired, resubmit with a new access token"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"TokenExpired"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorMessage","detail":{"type":1,"value":"Access token has expired, resubmit with a new access token"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.RequestId","detail":{"type":1,"value":"b63b27d0-277f-40ee-a001-30dd085fa168"}}],"exceptionCulprit":1}}}

Re: Reports in service will not refresh after gateway credential update

Bananathan — Tue, 23 Jul 2024 10:10:58 GMT

Hi, thank you for the reply.

I meant by update that I have changed the credentials today (and edited the credentials to upto date credentials for each gateway connection).

I am not sure what gateway version I am on - I noticed an update in July for Gateways - could that have caused the error?

Just an aside, seems I'm not the only one with this issue: https://community.fabric.microsoft.com/t5/Service/All-reports-are-stuck-at-refreshing-status/m-p/4054029#M240133

Potentially restarting the gateway may fix it - I will speka to my IT admins and try this. Weird to see no word from Microsoft or nothing on the status page.

Reports in service will not refresh after gateway credential update

Bananathan — Tue, 23 Jul 2024 09:48:46 GMT

I have updated the gateway credentials after refresh errors last night. However, after updating and pressing refresh, all the reports are stuck refreshing and it will not complete. They are still running now 2 hours later.

The reports have pretty small datasets and have never had an issue the past year that they've been published. I also cannot publish from the desktop - that seems to hang too.

Anyone experienced an issue like this before? It's very hard to figure out the problem when there is no error message!

Multiple dates per ID - only use closest date to selected date for a measure

Bananathan — Tue, 14 Mar 2023 12:44:43 GMT

Sorry for the title being kinda complex - I will try to explain better here:

I have the following (simplified) dataset. Anytime an employee changes (e.g. promoted or switched department) in their record, a new row is added at the end of the month The most recent row is blank.

I also have a date slicer:

I have created a calculated column that changes the blank date into the previous date + 1 month. I also have a measure that will give me the closest date for each employee that is less than the selected date, or if there isn't one, it will give me the calculated column date I just mentioned. To show you what I mean: see the 3 images below. The ID 4364 has the following end dates: 31/03/2022/ 31/07/2022 and blank. Therefore when I select June, the first date is the closest, for July the second date is closest and past July it will give my calculated column of the previous date +1 month (essentially the third blank date).

Here is the measure that gives me the closest date:

Latest Selected Date =

VAR End_of_Month = EOMONTH( SELECTEDVALUE('Date Table'[Date]),0 )

RETURN

CALCULATE (

MAX ( 'Data'[Previous Date + 1 month] ) ,

ALLEXCEPT ( 'Data' , 'Data'[Id]) ,

'Data'[Previous Date + 1 month] <= End_of_Month

)

What I'm trying to do is run a count on ID based on the selected date that will only use the row that matches the above measure's calculated date for each ID. Here is what I've got so far.. but does not work:

CALCULATE(

COUNT(''[Id]),

FILTER(

'Data',

'Data'[Previous Date + 1 month] = [Latest Selected Date]

)
)

In this measure, I believe my filter for the [Latest Selected End Date] is just the same date as the date in the slicer, it isn't being split per ID, how would I go about doing this?

Re: How to input start of financial year based on selected date into measure?

Bananathan — Fri, 23 Sep 2022 09:05:33 GMT

Awww man this has been bothering the hell out of me, but your solution worked! Thank you so much

How to input start of financial year based on selected date into measure?

Bananathan — Thu, 22 Sep 2022 12:55:36 GMT

Hi,

I have a date slicer that selects the year and month (essentially gives me 30th of selected month and year)

My financial (fin) year runs 1st Apr - 30th Mar and I am trying to input the date '1st April of this fin year' based on the selected date in the slicer.

For example, if I select February 2022 in the slicer then I need 1st April 2021.

I have a date table with a fin year field (21-22, 22-23, etc.) - I am trying to write DAX to give me 1st April of that fin year using this fin year field as a comparison, but can't figure out how to do this. I've tried DATE(), but I can only get this to work if the year of the selected date happens to be the same as the fin year. Of course, this isn't the case for Jan-Mar.

How can I use selecteddate to create '1st April of this financial year'?

Re: Image Quality lowers upon Publishing Report

Bananathan — Fri, 09 Sep 2022 15:31:29 GMT

Thank you, that has fixed my issue :). Power BI really is amazing and you can do the most complicated **bleep** and yet it is hilariously bad at some super basic things..

IF Statement does the opposite of what I've typed

Bananathan — Thu, 08 Sep 2022 12:46:06 GMT

So I'm very confused and I've probably missed something obvious but I have these two dates. The one on the left is a selected date in a slicer and the one on the right is the date from a row of data I'm trying to compare:

And this measure: (Above date on left is End_of_Month and date on right is [Contractual Leave Date])

VAR End_of_Month = EOMONTH( SELECTEDVALUE('Date Table for Measures'[Date]),0 )

RETURN

IF(

'HR Turnover Data'[Contractual Leave Date] > End_of_Month,

"True",

"False"

)

The statement returns true for the above and switching to a less than sign returns false. Essentially the opposite of what my data would suggest. Any ideas why this is happening?

Edit 1: To add, I've noticed the measure DOES work for dates larger than the selected date, it just also returns true for dates below the selected date. Anything blank it returns as FALSE, so something seems to be wrong with the dates. The format of each is the same and I have other measures using the exact same two dates that work perfectly fine.

Image Quality lowers upon Publishing Report

Bananathan — Wed, 27 Jul 2022 12:11:04 GMT

This only happens to a couple images, all images in the report are PNG, the image that becomes blurry is higher quality than the one that doesn't:

The image on the right in desktop:

Once published in the service:

I can't tell why the image is being compressed or lowered in quality so much, anyone any ideas? Thank you.