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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
manuelho
New Member

Native Query greyed out

Hi there,

 

i am getting data from Smartsheet and would like to create an incremental refresh. Unfortunately "View native query" is greyed out.

I've checked all the other threads in this forum how to fix this problem but still it is greyed out. Source column is date/time format. Even Navigation step has greyed out native query.

 

Any idea?

 

Thanks

Manuel

2 ACCEPTED SOLUTIONS
HotChilli
Super User
Super User

It means query folding is not taking place.  This is either because the source does not support it or there are steps in the query that break it.

View solution in original post

The Smartsheet connector is limited, and the connector/drivers from CDATA are more capable, though come with a $$$ price tag.   Options to determine query folding would be to open a Smartsheet Support Case and engage with the Smartsheet Community for peer support.  Unfortunately, am not sure if there is an upstream tool from SmartSheet that would indicate Query Folding.  You may want to

explore your options around the use of the API if that returns the data you are interested in.

View solution in original post

5 REPLIES 5
manuelho
New Member

Ok, thanks for the reply. Guess i have to write smartsheet guys to support this function in future.

Thank you for the feedback.   If the reply added to this contributed to this conversation has been helpful, please mark it as a solution and apply kudos so that others with a similar question are able to find an answer quickly.

manuelho
New Member

Thanks HotChilli. 

How to find out if Smartsheet supports query folding? 

Steps - there is just the source and nivigation step.

The Smartsheet connector is limited, and the connector/drivers from CDATA are more capable, though come with a $$$ price tag.   Options to determine query folding would be to open a Smartsheet Support Case and engage with the Smartsheet Community for peer support.  Unfortunately, am not sure if there is an upstream tool from SmartSheet that would indicate Query Folding.  You may want to

explore your options around the use of the API if that returns the data you are interested in.

HotChilli
Super User
Super User

It means query folding is not taking place.  This is either because the source does not support it or there are steps in the query that break it.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors