Forum Discussion

cmotisi's avatar
cmotisi
New Member
9 years ago
Solved

Schedule Refresh with ODBC Source

HI, I have a problem to schedule a refresh of data with ODBC Source. I have an on-premise data gateway (not personal) installed on machine. When I configure gateway and Datasource on Manage Gateway...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    cmotisi,

    Do you connect to Excel/csv files stored in SharePoint Online?

    If so, you are combining online data sources and on-premises data source in a single dataset, in this scenario, you would need to use personal gateway instead of on-premises gateway to refresh your dataset as currently on-premises gateway doesn't support OAuth type authentication and thus it is not possible to add the Excel/CSV data source withine on-premises gateway.

    However if you connect to Excel/csv files tored in on-premises SharePoint, please add the Excel/csv data source within on-premises gateway, then you will be able to use on-premises gateway to refresh your dataset.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
9 years ago

cmotisi,

Does your dataset only contain the ODBC data source? Please go to File -> Options and settings ->Data source settings in Power BI Desktop to check data sources and post a screenshot about the data sources.

Besides, please post a screenshot about the connection string you use to connect to ODBC data source under on-premises gateway.

There is also a similar thread about how to add ODBC data source within on-premises gateway for your reference.

Regards,
Lydia

cmotisi's avatar
cmotisi
New Member
9 years ago

My dataset contains ad ODBC Datasource and excel/csv datasouce, like following:

 

 

Thank's

Claudio

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    cmotisi,

    Do you connect to Excel/csv files stored in SharePoint Online?

    If so, you are combining online data sources and on-premises data source in a single dataset, in this scenario, you would need to use personal gateway instead of on-premises gateway to refresh your dataset as currently on-premises gateway doesn't support OAuth type authentication and thus it is not possible to add the Excel/CSV data source withine on-premises gateway.

    However if you connect to Excel/csv files tored in on-premises SharePoint, please add the Excel/csv data source within on-premises gateway, then you will be able to use on-premises gateway to refresh your dataset.

    Regards,
    Lydia

    • cmotisi's avatar
      cmotisi
      New Member
      9 years ago

      Yes, I Connect to Excel/Csv files on SharePoint Online on Office365.

      I'll try to install a personal gateway.

       

      Regards,
      Claudio