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...
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

Pragati11's avatar
Pragati11
Icon for Super User rankSuper 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
      Icon for Super User rankSuper 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi Pragati11 upon looking at my PBIX i am unable to changet the \ to /. The file path was determined when i added the excel file to Power BI