Forum Discussion
Smokey24
6 years agoHelper I
Incremental refresh with select statement
Hi, I want to incremental refresh and have set the parameters and published the dataset to the server. We are using an on-premise gateway and I got added as a user. For data load I am using a se...
GilbertQ
6 years agoSuper User
Hi there
When using incremental refresh you have to either use a table or view for incremental refresh to work.
With regards to your question on the datasource in the Gateway I would suggest going into your PBIX and clicking on Transform data and selecting Data Source Settings.
Take those settings and add them into your Gateway Data source in the Power BI Service.
When using incremental refresh you have to either use a table or view for incremental refresh to work.
With regards to your question on the datasource in the Gateway I would suggest going into your PBIX and clicking on Transform data and selecting Data Source Settings.
Take those settings and add them into your Gateway Data source in the Power BI Service.