Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Confirming Schedule Refresh SharePoint

Good morning all,   Please pardon all the long winded details...   I need to make sure how refresh works with data pulled from an Excel file in SharePoint. I have the Power BI pro license.   I'...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    Sorry to reply late. Is the below screenshot the same as your scenario?

     

    If it is, try this:

    1. Add data source of SQL Server and then maps to it.

    2. Apply.

    3. Edit credentials of SharePoint.

     

    Then, you can set Scheduled refresh.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

 

Sorry to reply late. Is the below screenshot the same as your scenario?

 

If it is, try this:

1. Add data source of SQL Server and then maps to it.

2. Apply.

3. Edit credentials of SharePoint.

 

Then, you can set Scheduled refresh.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

no worries Icey , it's a busy week all round...

 

That seems to work..! I missed seeing the screen you show, with the data mapping. I went through the steps you outlined and so far it's been refreshing data on schedule for the last 4 days. Good to go..!

 

thanks for the help, have a great weekend