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

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

    • Pragati11's avatar
      Pragati11
      Icon for Super User rankSuper User
      5 years ago

      Hi Anonymous ,

       

      Can you share some screesnhot please? It is hard for me to understand why you are not able to change the path.

      Also, I realised this path points to a "Q drive" . Does this drive exist somewhere locally on your machine?

       

      Thanks,

      Pragati

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hello, Pragati11 So i managed to change the path names through Transform Data on the PBIX 🙂 However one report is still gining me an issue. See below

         

        The Q drive is on our business server along with the Gateway