Forum Discussion

PBI_user27's avatar
PBI_user27
Frequent Visitor
3 years ago

Data source from one drive in on-prem report server

Hi All   I have some data source that is connected to our organisational one drive (excel). In order to do a scheduled refresh, I'm required to input the credentials but organisation authenication ...
credentials
Report Server
jaweher899's avatar
jaweher899
Icon for Impactful Individual rankImpactful Individual
3 years ago

If organizational authentication is not available as an authentication type, you may need to set up a data gateway to allow for scheduled refresh of your Excel data source from OneDrive in Power BI.

Here are the high-level steps to set up a data gateway:

  1. Download and install the data gateway software from the Power BI service.
  2. Sign in to the data gateway using your organizational credentials.
  3. Configure the data source credentials for the data source you want to refresh.
  4. Create a new data source in Power BI, selecting the data gateway you just installed.
  5. Configure scheduled refresh for the data source in Power BI.

Once you have set up the data gateway and scheduled refresh, you should not need to enter your credentials every time you refresh the data.