Power BI Service Issue

[Anonymous]

I keep getting issues with my scheduled/manual refreshes in Power BI service recently. Since about 29 August 2022. Manual input tables such as date tables are also having issues which makes no sense to me.

Does anyone know what's the issue? Could it be due to the latest update on 29/8/2022?

An error occurred while processing the data in the dataset.

Refresh failed:

<Dashboard Name> has failed 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.

<ccon>DataSource.Error: <ccon>SharePoint</ccon>: Request failed (<ccon>https://<Company>.com/sites/<Document path>/DN MONITORING V1_xlsx/_api/contextinfo</ccon>): <ccon>429</ccon>. DataSourceKind = <ccon>SharePoint</ccon>. DataSourcePath = <ccon>https://<Company>.com/sites/<Document path>/DN%20MONITORING%20V1_xlsx/_api/contextinfo</ccon>. SPRequestGuid = <ccon>c1e760a0-d0bc-d000-6398-e016d99b0213</ccon>. </ccon>. The exception was raised by the IDbCommand interface. Table: DATE_TABLE.

Next refresh for <Dashboard Name> is scheduled for September 2, 2022 4:00 UTC.

[v-cazheng-msft]

Hi @Anonymous,

May I know whether this issue still exist? Could you please try to download the dataset report to a pbix fila and refresh it in Power BI Desktop? Also, please check in Power Query whether there is any error or warning?

Best Regards,

Community Support Team _ Caiyun

[Anonymous]

Dear Caiyun,

Thank you so much for your response. Yes the issue still exists. A random table is failing in terms of connection during refresh, and only 1 out of every 4 refreshes it goes through, sometimes failing more than 4 times and the scheduled refresh is switched off.

Thank you.

With regards,

Joel

[khurtgen]

I am having a similar issue since late August.  Multiple Data flows having issues refreshing despite staggered times and workspaces.  My data source is Project Online API (Odata) Suggestions???

[khurtgen]

May I please have an update on this issue?  I have seen multiple posts on this and it is crippling my dataflow refreshes that one of 3 or 4 goes through and reports are not up to date.  My dataflows run singularly in Workspaces with no reports and only 2-3 other dataflows. We are a small Project Online Odata datasource using api to extract dataflow data.  None are complex.  None overlap.  None have failled until recently on a regular basis.  Have been using since January.  Please provide update if there is one.  Did not have issue until approx Sept 1 @Anonymous . @v-cazheng-msft