Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Unable to connect to the data source undefined

We are utilizing an enterprise Data Gateway in order to schedule our refreshes. I have an online data source from Smartsheet (like online Excel) as well as SQL Server. I can pull in the tables from t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Courtneyfinke,

 

This is because of the two sources which establshed connection for your data model.

 

Data Management Gateway would require data source to be defined in the PBI service. You can provide either SQL Server or Excel Online in a time.

 

If your PBI report has one connection to SQL server, then it would be fine or the vise versa.

 

The solution is to import your online excel data in to sql server table and build relationship between objects and then configure your gateway for data refresh. So, you will have only one source to confiure gateway.

 

Regards,

Pradeep

Anonymous's avatar
Anonymous
Not applicable
7 years ago

That's not really a viable solution because this list is being updated often by other people in our organization and would not be a one time import into SQL Server--is there a way to import the table from Excel Online into SQL Server any time someone makes a change?

 

Will there be a time when the Data Management Gateway would allow two data sources?