Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

Power BI Service Issue

Submitted by Anonymous on ‎09-07-2022 02:16 AM

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.

Status: Investigating

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

See more ideas labeled with:
4 Comments (4 New)
Comments
v-cazheng-msft
Community Support
Community Support
‎09-07-2022 10:46 PM
Status changed to: Investigating

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
Not applicable
‎09-08-2022 02:14 AM

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
Regular Visitor
‎09-08-2022 02:21 PM

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
Regular Visitor
‎09-13-2022 08:46 AM

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 

Idea Statuses