Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

SmartSheet cannot be added to data gateway

Error message: Extension{"extensionDataSourceKind":"Smartsheet","extensionDataSourcePath":"Smartsheet"}

Cannot be added to gateway

 

Successfully have an on premise connection to SQL Sever.

 

My credentials did not change, but I re-entered them as a fix attempt & that did not solve it. Recently updated PoweBI version.

 

Status: Investigating
Comments
noannish
Frequent Visitor

I should add it's just the gateway, I can still run a manual refresh successfully.

Anonymous
Not applicable

Hi @noannish ,

 

I wasn't able to reproduce your question, does this question still exist?
Please take a look at the following THREAD to see if it helps

Smartsheet settings for enterprise gateway - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Caitlyn

noannish
Frequent Visitor

@Anonymous Thank you for taking the time to respond. 

 

Unfortunately I don't see the connect directly option under gateway connection.  This report uses both SqlSever and SmartSheet as a datasource.

 

I have the on premises set to 'on' for the SqlServer update.

 

The gateway is selected and then it lists the data sources included in the dataset: 

with SqlServer successfully mapping

and 'Extension{"extensionDataSourceKind":"Smartsheet","extensionDataSourcePath":"Smartsheet"}' as the other data source and for mapping says 'Cannot be added to gateway'