# Power BI API failing

**URL:** <https://forum.asana.com/t/power-bi-api-failing/156733>\
**Category:** API & Developers\
**Created:** [9 March 2022 15:47 UTC](https://forum.asana.com/t/power-bi-api-failing/156733 "2022-03-09T15:47:34Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Will.S](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/will.s/32/43448_2.png) [@Will.S](https://forum.asana.com/u/Will.S)\
**Post date:** [9 March 2022 15:47 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/1 "2022-03-09T15:47:34Z")

</div>

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](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](http://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 |

---

<div class="post-metadata">

**Author:** ![anon87716909](https://luna1.co/8d76cd.png) [@anon87716909](https://forum.asana.com/u/anon87716909)\
**Post date:** [17 April 2023 17:24 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/2 "2023-04-17T17:24:28Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![John\_Vu](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/john_vu/32/97235_2.png) [@John\_Vu](https://forum.asana.com/u/John_Vu)\
**Post date:** [14 June 2023 16:59 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/3 "2023-06-14T16:59:43Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Will.S](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/will.s/32/43448_2.png) [@Will.S](https://forum.asana.com/u/Will.S)\
**Post date:** [14 June 2023 17:45 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/4 "2023-06-14T17:45:02Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![John\_Vu](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/john_vu/32/97235_2.png) [@John\_Vu](https://forum.asana.com/u/John_Vu)\
**Post date:** [14 June 2023 17:54 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/5 "2023-06-14T17:54:57Z")

</div>

Hi @Will.S,

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

---

<div class="post-metadata">

**Author:** ![anon87716909](https://luna1.co/8d76cd.png) [@anon87716909](https://forum.asana.com/u/anon87716909)\
**Post date:** [27 June 2023 10:48 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/6 "2023-06-27T10:48:06Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![John\_Vu](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/john_vu/32/97235_2.png) [@John\_Vu](https://forum.asana.com/u/John_Vu)\
**Post date:** [10 July 2023 23:36 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/7 "2023-07-10T23:36:36Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![anon87716909](https://luna1.co/8d76cd.png) [@anon87716909](https://forum.asana.com/u/anon87716909)\
**Post date:** [11 July 2023 14:23 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/8 "2023-07-11T14:23:37Z")

</div>

@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.

---

<div class="post-metadata">

**Author:** ![John\_Vu](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/john_vu/32/97235_2.png) [@John\_Vu](https://forum.asana.com/u/John_Vu)\
**Post date:** [11 July 2023 16:24 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/9 "2023-07-11T16:24:24Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![anon87716909](https://luna1.co/8d76cd.png) [@anon87716909](https://forum.asana.com/u/anon87716909)\
**Post date:** [4 August 2023 18:29 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/10 "2023-08-04T18:29:10Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![anon87716909](https://luna1.co/8d76cd.png) [@anon87716909](https://forum.asana.com/u/anon87716909)\
**Post date:** [21 August 2023 17:40 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/11 "2023-08-21T17:40:51Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![anon87716909](https://luna1.co/8d76cd.png) [@anon87716909](https://forum.asana.com/u/anon87716909)\
**Post date:** [7 November 2023 14:14 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/12 "2023-11-07T14:14:07Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![John\_Vu](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/john_vu/32/97235_2.png) [@John\_Vu](https://forum.asana.com/u/John_Vu)\
**Post date:** [7 November 2023 18:09 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/13 "2023-11-07T18:09:31Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![anon87716909](https://luna1.co/8d76cd.png) [@anon87716909](https://forum.asana.com/u/anon87716909)\
**Post date:** [7 November 2023 18:13 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/14 "2023-11-07T18:13:21Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![anon87716909](https://luna1.co/8d76cd.png) [@anon87716909](https://forum.asana.com/u/anon87716909)\
**Post date:** [19 January 2024 11:16 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/15 "2024-01-19T11:16:47Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Emily\_McFeely](https://luna1.co/8d76cd.png) [@Emily\_McFeely](https://forum.asana.com/u/Emily_McFeely)\
**Post date:** [29 January 2024 19:54 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/16 "2024-01-29T19:54:29Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Larry\_Berger\_lpb](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/larry_berger_lpb/32/276017_2.png) [@Larry\_Berger\_lpb](https://forum.asana.com/u/Larry_Berger_lpb)\
**Post date:** [29 January 2024 20:06 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/17 "2024-01-29T20:06:06Z")

</div>

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

> [@Power BI - Asana refresh failure](https://forum.asana.com/t/power-bi-asana-refresh-failure/678563):
>
> 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…

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

---

<div class="post-metadata">

**Author:** ![anon87716909](https://luna1.co/8d76cd.png) [@anon87716909](https://forum.asana.com/u/anon87716909)\
**Post date:** [29 January 2024 20:13 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/18 "2024-01-29T20:13:38Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Emily\_McFeely](https://luna1.co/8d76cd.png) [@Emily\_McFeely](https://forum.asana.com/u/Emily_McFeely)\
**Post date:** [1 August 2024 17:07 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/19 "2024-08-01T17:07:45Z")

</div>

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

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

---

<div class="post-metadata">

**Author:** ![Larry\_Berger\_lpb](https://sea2.discourse-cdn.com/asana/user_avatar/forum.asana.com/larry_berger_lpb/32/276017_2.png) [@Larry\_Berger\_lpb](https://forum.asana.com/u/Larry_Berger_lpb)\
**Post date:** [1 August 2024 18:35 UTC](https://forum.asana.com/t/power-bi-api-failing/156733/20 "2024-08-01T18:35:33Z")

</div>

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](https://asana.com/guide/help/faq/connectivity#gl-troubleshooting), then please create a support ticket: see [How to contact our Support Team](https://go.asana.com/supportteam).

Thanks,

Larry

[Next page](https://forum.asana.com/t/power-bi-api-failing/156733.md?page=2)
