Power BI API failing

English Forum Developers & API
1

Hi all, I’ve had a few portfolios set up as datasets for Power BI for a awhile now and everything’s worked perfectly and suddenly around noon PST yesterday I’ve not been able to get anything to refresh, even trying to map a single project fails. Is it possible that there’s something attached to my credentials that is hanging causing failures since the Asana status page is green for everything.

Data source error: DataSource.Error: The underlying connection was closed: An unexpected error occurred on a receive.. https://reporting-api.integrations.asana.plus. . The exception was raised by the IDbCommand interface. Table: Q1 Archive.
Cluster URI: WABI-US-NORTH-CENTRAL-E-PRIMARY-redirect.analysis.windows.net
Activity ID: f2cbdab6-06be-463c-a66a-35047c47b7b2
Request ID: 310f562c-ff61-463c-bc5c-cea9ce192ece
Time: 2022-03-08 22:36:01Z
2

I am currently having similar issue when refreshing data. It is taking an incredible amount of hours (instead of 20/30 min). Does anybody knows what is happening?

3

Hi @Will.S and @anon87716909,

Can you both try to reproduce the issue again. Our engineering team needs some more logs to help debug the issue.

4

This issue was from March of 2022, not sure that any logs would be really helpful. But please let me know if there’s anything you do need.

5

Hi @Will.S,

Based off your reply I am guessing this issue has been resolved?

6

Today the issue came up again. I am refreshing data from Power BI Desktop and it is taking too long, and then the message of credentials appears, even though I check credentials before the data refresh.

7

Hi @anon87716909,

Sorry I missed this message. Do you mind re-producing this and then notifying me (@mention me) as soon as possible so our team can look at the logs.

8

@John_Vu , thanks for reaching me out. The day after the ticket was moved to the BUGS section, the issue disappeared.
I’d like to mention that this usually happens once a month.

9

Hi @anon87716909, thank you for the quick reply and ok, I’ll let our team know. Keep me posted on any new issues as they come up as well. Thanks.

10

Hi @John_Vu , it is happening again. Since yesterday eod. Not able to refresh data using Power BI Desktop.

11

@John_Vu sent you an e-mail with the screen shots

1 Like
12

Hi, I am not able to refresh data from Power BI Desktop with data coming from Asana again. This is causing some bad experience with execs.

13

Hi @anon87716909, I’ll reach out to you to get more details.

14

What I noticed today…
I created a simpler Power BI dataset, so I added 3 Asana links. I took a long time to have data in Power BI. BUT when I tried to append the 3 tables into 1, this is where it seems to be the problem, as it never finishes the process.

15

Hi. Power BI not refreshing Asana data again since Wednesday afternoon. Do not know why

Power BI - Asana refresh failure
16

Receiving data source error again, but only for Asana to PBI all other data sources are being read fine in PBI.

17

@anon87716909, @Emily_McFeely, and maybe @John_Vu, please note this bug fix in progress:

I think it would be best for you to comment on that thread now instead of this one.

(I could merge this thread with that one, but since it started a long time ago, not sure if that’s correct.)

Thanks,

Larry

18

Hi. Thanks. I will keep updating in the Power BI - Asana refresh failure due to the following:
a) it is located in the Bugs forum
b) more people contributed to report similar issue

1 Like
19

My Power BI API has been Failing for 2 days now. Anybody else having similar issues?

@lpb Is this another bug that needs to be addressed similar what happened back in January?

20

Hi @Emily_McFeely,

Sorry to hear that. This category Developers & API is primarily for development/technical issues so I’d recommend creating a new topic in Tips and Tricks, or:

Try these troubleshooting steps, then please create a support ticket: see How to contact our Support Team.

Thanks,

Larry