Lekha92's avatar
Lekha92
New Member
9 years ago
Status:
Needs Info

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

Content Packs
Dashboards
Gateways

7 Comments

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    Lekha92

     

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

     

     

    Best Regards,

    Herbert

  • Lekha92's avatar
    Lekha92
    New Member
    9 years ago

     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's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    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's avatar
    Anonymous
    Not applicable
    9 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
    acefull
    Frequent Visitor
    9 years ago

    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

Completed Ideas