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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ianboothman84
Helper II
Helper II

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

    ianboothman84_0-1617806544419.png

     

    Im confused. Worked fine in January 

     

    please help 🙂

     

    Ian 

1 ACCEPTED SOLUTION

Hi @ianboothman84 ,

 

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

Pragati11_0-1617970182464.png

The error points to invalid credentials.

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

11 REPLIES 11
HarishKM
Impactful Individual
Impactful Individual

@ianboothman84 Hey 
Use below link .

 

Troubleshoot the issue 

You have update your data credential .

then your gateway will work fine .

Pragati11
Super User
Super User

Hi @ianboothman84 ,

 

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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

 

ianboothman84_0-1617815570815.png

 

Hi @ianboothman84 ,

 

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

Pragati11_0-1617869859416.png

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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

Hi @ianboothman84 ,

 

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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

ianboothman84_0-1617965005761.png

 

Hi @ianboothman84 ,

 

Glad that you were able to fix the other error by changing the path. I suspect same reason for this error as the error is very much similar to your earlier one.

Does this M drive exist?

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Hi @Pragati11 so all the paths are mapped correctly in the PBIX and gateway. When the system fails a scheduled refresh it shows the error code with a \ even though they have been changed 🙂

Hi @ianboothman84 ,

 

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

Pragati11_0-1617970182464.png

The error points to invalid credentials.

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

hi @Pragati11  i have my IT team working on this. I have carried out the actions you have recomneded. But we may have a Gateway credential issue. Thanks for the support

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.