Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Data Refresh error

My datasource is an excel file on Sharepoint. Recently the file was moved, but i've moved it back into the original path. But now i'm not able to refresh the Power BI Dashboard. There is an error icon next to the datasource. Here's an email from Microsoft:

 

OneDrive refresh for Dashboard (7).xlsx has been disabled. You can learn about common reasons refresh fails in our help topics or reach out to our Community for help. As always, you can also contact support.

If you contact support for this issue, please provide them with the following information:

Activity Id: 32d1af0c-9748-4159-8b4b-77f3664450e6

Request Id: fff4727e-2d18-46c0-8977-a5741150d8b0

Cluster Name: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net

Refresh Start Time: 01/11/2017 09:10:05Z

Refresh End Time: 01/11/2017 09:10:07Z

 

I created the dashboard from scratch on the web version, not desktop

 

Please helpe me ASAP

Status: Needs Info
Comments
v-haibl-msft
Employee

@Lekha92

 

Could you please check if the “OneDrive Refresh” option is turned on in Datasets settings as below?

Data Refresh error_1.jpg 

 

Best Regards,

Herbert

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
Lekha92
New Member

 @v-haibl-msft - Yes, it used to be on when the refresh was working. Now, it keeps getting turned off and i get an email notifying me that OneDrive refresh has been disabled - even after i turn it back on myself

v-haibl-msft
Employee

@Lekha92

 

In Power BI Service, can the report be shown properly after you move the excel file back to original path?

 

Best Regards,

Herbert

Anonymous
Not applicable

My data refreshed fine in PBI desktop but gets the following error in PBI Service, Please help?                      Thanks in advance!

Anonymous
Not applicable

The data source eis Oracle 11G

This is a new implementation - always had the issue where the datasource is freshed in PBI Desktop but fails refresh in the PBI Service. It happens to all the data sources, all Oracle, 8 total.

 

Here's an example of the error:

Something went wrong.

 

Cannot connect to the mashup data source. See error details for more information.
Please try again later or contact support. If you contact support, please provide these details.

 

Underlying error code-2147467259

Underlying error messageOracle: ORA-01722: invalid number

DM_ErrorDetailNameCode_UnderlyingHResult-2147467259

Microsoft.Data.Mashup.ValueError.DataSourceKindOracle

Microsoft.Data.Mashup.ValueError.DataSourcePath:      REDACTED by poster

Microsoft.Data.Mashup.ValueError.ErrorCode-2147467259

Microsoft.Data.Mashup.ValueError.MessageORA-01722: invalid number

Microsoft.Data.Mashup.ValueError.ReasonDataSource.Error

Cluster URIWABI-US-EAST2-redirect.analysis.windows.net

Activity IDd9d414ef-cbe6-4d08-9d9e-c0ccd8a00dea

Request ID000a8a18-d8d4-1a74-a0c9-0eeea88c023a

Time2017-02-03 21:15:22Z
Get help

 

acefull
Frequent Visitor

I have same issue. could someone please help?

 

 

OneDrive refresh for StageReport.csv has been disabled. You can learn about common reasons refresh fails in our help topics or reach out to our Community for help. As always, you can also contact support.
If you contact support for this issue, please provide them with the following information:
 
Activity Id: 6536adc0-bb72-43ce-a065-3eeb66b11b3d
Request Id: 259951e3-4b89-4c12-b50d-27b333a2522a
Cluster Name: WABI-WEST-US-redirect.analysis.windows.net
Refresh Start Time: 08/15/2017 20:26:11Z
Refresh End Time: 08/15/2017 20:26:11Z