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 is not available under the authentication type. Tried anonymous and windows authenication, the error shows:

 

"The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly."

credentials
Report Server

1 Reply

  • jaweher899's avatar
    jaweher899
    Impactful 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.