Forum Discussion

drallam's avatar
drallam
Helper II
8 years ago

Schedule Refresh for Excel Sharepoint Files.

Hi all,   Sorry for posting this type of question. I have researched a lot and found multiple posts and especially this docuemntation from PowerBI itself. Documentation , Sharepoint Post Post 2 but...
Need Help
Show and Tell
Tips and Tricks
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
8 years ago

drallam

 

As mentioned in the document, if you directly connect the Excel workbook hosted on SharePoint Online, you don't need Gateway. But if this Excel workbook connects on-premise data sources, you need to make sure Power BI can connect the on-premise data sources so that Gateway is required. If this on-premise data source is not supported by On-Premise Gateway (Enterprise Gateway), you have to use Personal Gateway.

 

Regards,

  • drallam's avatar
    drallam
    Helper II
    8 years ago

    v-sihou-msft

     

    Can you please elaborate this statement "But if this Excel workbook connects on-premise data sources, you need to make sure Power BI can connect the on-premise data sources so that Gateway is required." 

    I tagged you in another post of me using the Sharepoint Online Excel files. What different shoudl I do to connect the Excel Files to a on-premise Data Sources, do you mean Sharepoint On-Premise instead of Sharepoint Online as GilbertQ mentioned?

    Thanks for your input.