Power BI - Asana refresh failure

Important note: To help us resolve your issue as quickly as possible, please ensure to fill out all the sections below. Do not share any private information such as email addresses or phone numbers - This is a public Forum!


Power BI desktop is not refreshing Asana data. This failure started on Jan 17, 2024, and this is causing problems when executives want to know current project status.

When we start Asana data refresh in Power BI desktop, it starts refreshing, and never ends, and many times a message of credentials appear.

We have Asana Business plan, and we have been using Power BI integrated with Asana for 1 year.

Please we need a urgent solution for this as this is causing business impacts.

1 Like

Now I am receiving this error message

1 Like

I am having the same issue. I submitted a support ticket. Hopefully this is resolved quickly!

I am also having the same issue.

This is the error I got when my dataset attempted to refresh:

"Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

[ValidateMarkupTags][ccon][ccon]asana_api_exception[/ccon]: [ccon][/ccon]. error = [ccon]asana_api_exception[/ccon]. error_description = [ccon][/ccon]. [/ccon]. The exception was raised by the IDbCommand interface. Table: Tasks."

Same here:

Data source error: [ValidateMarkupTags][ccon][ccon]asana_api_exception[/ccon]: [ccon][/ccon]. error = [ccon]asana_api_exception[/ccon]. error_description = [ccon][/ccon]. [/ccon]. The exception was raised by the IDbCommand interface. Table: Tasks.
Cluster URI: WABI-US-NORTH-CENTRAL-E-PRIMARY-redirect.analysis.windows.net
Activity ID: 3ed352ca-a928-4bda-8f45-99ff943a7323
Request ID: 26c9b722-c2c2-4ee7-92cb-7c1e2ac4ca6d
Time: 2024-01-25 23:26:43Z
Details # Type Start End Duration Status Error


1 Data 1/25/2024, 3:00:45 PM 1/25/2024, 3:01:06 PM 00:00:21.032 Failed (Show)
2 Data 1/25/2024, 3:02:06 PM 1/25/2024, 3:02:53 PM 00:00:46.378 Failed (Show)
3 Data 1/25/2024, 3:04:53 PM 1/25/2024, 3:20:27 PM 00:15:34.568 Failed (Show)
4 Data 1/25/2024, 3:25:27 PM 1/25/2024, 3:26:43 PM 00:01:15.586 Failed (Show)

Additionally when trying to modify the data source credentials it looks like the issue is clearly on the asana api integration side.

Screenshot 2024-01-25 at 4.28.55 PM

I am also experiencing the same issue across multiple Power BI desktop dashboards linked to Asana:

Also, Iā€™m not sure how theyā€™re able to say the API has no downtime while this issue persistsā€¦

1 Like

Yes, this is something that made me believe I was doing something wrong.

Hi everyone, thank you for reporting this and sorry for the trouble. Weā€™ve received some similar reports from other users, and the case has already been escalated to our Developers. I hope this can be fixed soon. Once I have any updates Iā€™ll let you know

2 Likes

Hello, Iā€™m being cautiously optimistic here but it looks like things are refreshing from Asana again - had a few taking a bit longer than normal so far, but it looks promising, whatever it was.

But by promising Iā€™m somewhere between an 25%-50% success rate with refreshing data, whereas yesterday it was 0%.

Chiming in that my issue has resolved. I was instantly able to log back in and re-establish my connection in both the downloaded PBIX and on the PowerBI app.

I also felt the frustration from this. Feels like the status page needs to be based on actual tests of the API instead of issue reports. Issue reports will only show up if and when people realize there is an issue and then take the steps to report it, the API could be down for hours before an issue gets reported. In checking today, the status page still shows green for yesterday despite our reported errors.

Would love to see Asana report out issues from their own testing rather than relying on the community to bring the problems to them.

Still the same status. Not working for me.

Itā€™s still hovering on the 25%-50% refresh success rate here. Not reliable enough to turn on automatic refreshes again.

But itā€™s getting more frustrating - Havenā€™t been able to refresh in > an hour, and now getting this error.

Failed to update data source credentials: [asana_api_exception] { ā€œerrorā€: ā€œinvalid_grantā€, ā€œerror_uriā€: ā€œhttps:\u002F\u002Fasana.com\u002Fdevelopers\u002Fdocumentation\u002Fgetting-started\u002Fauthenticationā€, ā€œerror_descriptionā€: ā€œThe code provided has expired.ā€ }Hide details

Activity ID: 40ff4506-8845-4d3b-a93a-5a25bc15a3ca
Request ID: 6574623e-6ac8-8966-236e-1f156b015111
Status code: 400
Time: Fri Jan 26 2024 17:26:07 GMT-0800 (Pacific Standard Time)
Service version: 13.0.22453.86
Client version: 2401.2.17636-train
Cluster URI: https://wabi-us-north-central-e-primary-redirect.analysis.windows.net/

Hi,

Sharing some additional information.

IĀ“ve been using Power BI desktop to refresh data just for the sake to try to understand what is going on.

Strangely enough till Saturday I couldnĀ“t get data refreshed, but on Sunday it worked well, and today (Monday) it got back to the same problem.

Seems there is something specific to Sunday that is not ā€œblockingā€ data to be refreshedā€¦

1 Like

Same experience here - It was fine Saturday night (~8pm in California) and Monday morning no refresh failure email until now.

It looks like the last successful refresh was at 730 am PST today, and the 8am refreshes (I have a lot of different portfolios refreshing) are still trying to refresh some 2 hours later.

Newest error

Last refresh failed: 1/29/2024, 9:41:15 AM
There was an error when processing the data in the dataset.Hide details

Data source error: [ValidateMarkupTags][ccon]DataSource.Error: Web.Contents failed to get contents from ā€˜[ccon]https://reporting-api.integrations.asana.plus/v1/schema[/ccon]ā€™ (503): [ccon]Service Unavailable[/ccon]. DataSourceKind = [ccon]Asana[/ccon]. DataSourcePath = [ccon]https://app.asana.com/0/portfolio/1204582429602874/list[/ccon]. Url = [ccon]https://reporting-api.integrations.asana.plus/v1/schema[/ccon]. [/ccon]. The exception was raised by the IDbCommand interface. Table: Tasks.
Cluster URI: WABI-US-NORTH-CENTRAL-E-PRIMARY-redirect.analysis.windows.net
Activity ID: 861a5c62-bc10-4a68-887e-cf0d4b82425e
Request ID: c62b60d2-b9d2-41a5-898e-119e97dad1cc
Time: 2024-01-29 17:41:15Z

Hi, I was wondering if you have any news about this issue. Not sure if you read the latest information on data flowing on Sunday but not todayā€¦

New error message.