Forum Discussion

WunWun's avatar
WunWun
Frequent Visitor
4 years ago
Solved

On-Premise Gateway - Web Data Sources Credentialing Issue

Hello everyone! I am managing my organizations Power BI Gateway and have run into a snag that is manageable now, but will not be soon.   Our customers prefer to use Excel files as the primary data ...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi WunWun ,

     

    As aj1973  said, you can try connecting the files on SharePoint without the gateway.

    As an addition,Power BI connects to your file on OneDrive about every hour automatically. So you don't have to worry about schedule refresh.

     

    Best Regards

    Community Support Team _ chenwu zhu

     

    Please consider Accept post which is helpful for you as the solution to help the other members find it more quickly.

     

aj1973's avatar
aj1973
Community Champion
4 years ago

Hi WunWun 

With data stored in Sharepoint online you don't need Gateway connection. How did you build your reports? online or using Power bi Desktop? Using desktop to connect to sharepoint is sometimes tricky whether it is a file or folder. Check Youtube, there is plenty of videos.

WunWun's avatar
WunWun
Frequent Visitor
4 years ago

Everything was built on Power BI Desktop.

 

If you do not need a gateway for SharePoint data sources, how can you schedule a data refresh?