Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

SQL and Excel Failed Schedule Refresh

Good Afternoon 

 

I have a Dashboard with SQL data and Excel data. On BI desktop the PBIX will complete a manual referesh absoulty fine. How ever fails on a Scheuled refresh. All excel docuemts are saved as .xlsx and we have installed the latest Gateway. 

 

Below is a copy of the failed report...

 

  • Underlying error code-2147467259
  • Underlying error messageCould not find a part of the path 'Q:\Resource and Planning\Cameron\U&R Raw.xlsx'.
  • DM_ErrorDetailNameCode_UnderlyingHResult-2147467259
  • Microsoft.Data.Mashup.ValueError.DetailQ:\Resource and Planning\Cameron\U&R Raw.xlsx
  • Microsoft.Data.Mashup.ValueError.ReasonDataSource.Error
  • Cluster URIWABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
  • Activity ID57692d3a-73e9-42f8-bcc3-6301ff8621c0
  • Request IDf18ffb8a-51bb-4fc8-b063-181ed5da26ea
  • Time2021-04-07 14:15:37Z

    Copy

     

     

    Again on the BI Websitethe Datasource is connected fine

     

    Im confused. Worked fine in January 

     

    please help 🙂

     

    Ian 

Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Anonymous ,

     

    Can you please check-up the credentials set-up for this file in Power BI service for setting up scheduled refresh?

    The error points to invalid credentials.

     

    Thanks,

    Pragati

11 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    Hi Anonymous ,

     

    Can you try modifying your path by removing any spaces in the FOLDER name? In the path you have spaces in folder names and your excel file name.

     'Q:\Resource and Planning\Cameron\U&R Raw.xlsx'

     

    Use "underscores" instead of spaces in filename.

    Spaces that I see in the path is:

    1. Q:\Resource and Planning\Cameron\U&R Raw.xlsx
    2. Q:\Resource and Planning\Cameron\U&R Raw.xlsx

    Please correct these and try again.

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      many thanks, i have made the adjustments as you recomended. But still failing to refresh 

       

       

      • Pragati11's avatar
        Pragati11
        Super User
        5 years ago

        Hi Anonymous ,

         

        The error you are getting clearly says your filepath is not right.

        You need to use forward slash "/" in your filepath. You are currently using backward slash which is not recognised in this form correctly.

         

        Thanks,

        Pragati