Incremental Refresh Understanding

Hi rajulshah ,

>>But whenever there is change in the data modelling, we need to go back to Power BI Desktop

If the change in data modelling don't change the structure of data model and the definition of Incremental Refresh, for example, just change some fields' values but not add data source, create column or measure, you needn't go back to Power BI Desktop : do the necessary changes, do full refresh and then re-publish the file. Unless you need to change the definition of Incremental Refresh again .

Otherwise, you just need to click refresh button in dataset or configure schedule refresh in Power BI Service. If the way getting your data is Directquery mode ( Incremental Refresh is not supported for the connect live mode) , you need to considerate if it is gotten from on premise data source(such as SQL Server Database) or cloud data source (such as Azure SQL Server Database).If it is the on premise data source, you need to install the Gateway and configure it . See:On-premises data gateway ,Manage your data source - SQL Server .

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.