I get this error when I try to schedule refresh a dashboard with Smartsheet data: "The given data source kind is not supported. Data source kind: Smartsheet." How is it that it's not supported but then in this article it appears it is: https://powerbi.microsoft.com/en-us/blog/visualize-your-smartsheet-data-in-power-bi/
6 Comments
- akruzel
Kudo Collector
Charles, here's a response I got from Microsoft support so I think this ticket is prematurely closed. Hi Adam, I received word back from the PG. It seems, at this time the gateways do not support the cloud SaaS connectors therefore giving you an error stating that the source kind is not supported. An ETA for a fix rollout is not yet listed but I can see that this is a known issue that they are working to resolve now. I encourage you to monitor the support page because when a fix is being rolled out it will be listed on the Power BI support site. I’m sorry for any inconvenience that this may cause and thank you for contacting Microsoft Pro Support Adam. - akruzel
Kudo Collector
Charles, I don't just have a single Smartsheet connection that I'm trying to refresh. I use it in a relationship with other queries that are pulling SQL Server data. - chass
Impactful Individual
Hello Adam, I just tested this and my refresh is working for Smartsheets. Can you also test a simple Smartsheet datasource? Thanks - chass
Impactful Individual
This should be working and even documented here: https://powerbi.microsoft.com/en-us/documentation/powerbi-content-pack-smartsheet/ As it is written for Microsoft by Smartsheet please contact them at: https://www.smartsheet.com/support Thank you! Chuck - flexfleetFrequent VisitorI connect to SmartSheets on many dashboards and they are currently auto refreshing. However I have a new SS dashboard I just rolled out that is throwing this exact error. My other SS dashboards are refreshing but not my new one. I'm wondering if the problem is an error that is throwing in the dataset that isn't reporting as an error in the desktop client but is on the web side. I'm trying to figure this one out right now....
- fbcideas_migusrNew MemberStatus added:Completed
Recent ideas
Support Fabric SQL Database with workspace-level inbound Private Link
Fabric SQL Database supports tenant-level Private Link but not workspace-level Private Link. Securing a small number of databases therefore requires enabling Private Link across the entire tenant, in...WorkFull2214 minutes agoAdvocate INew23Views1like1CommentPaste values in slicers for hierarchy data
Hierarchical slicers are widely used in enterprise reports (for example Product RCN > SKU Key, Region > Country > City, or GPP > Division > RCN > SKU). Users often need to bulk-filter by pasting valu...eddieisking20001 hour agoFrequent VisitorNew4Views0likes0CommentsPower Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes4 hours agoNew MemberNeed Clarification204Views3likes2CommentsMake Copilot Approval status for semantic model available through API
In recent versions fabric allowed to mark a semantic model as approved for copilot to reduce AI adoption friction. However there is no specific way for external governance application to analyse whi...FrançoisD4 hours agoFrequent VisitorNew12Views2likes0CommentsClone a workspace, including its data, to a new workspace
Description: Today there's no way to fully clone a Fabric workspace: git sync and Deployment Pipelines move item definitions only, not the underlying data; Warehouse's zero-copy CREATE TABLE ... AS ...gclements5 hours agoHelper IINew14Views1like0Comments