Incremental refresh users

[Anonymous]

Hi PowerBI_ers,

I am trying to set up incremental refesh. It look easy with some parameters set up  and some clicks but actually it is not working to my case. I ve found out that, in our database, the Date column is in type TEXT. As soon as i change it type to Date/Time to apply parameters RangeStart and RangeEnd. The data is not loading properly and can not "View native query". It works fine in desktop but it ll fail in the PowerBi Service

How to walk through this problem ? Any ideal

thanks in advance

[v-xicai]

Hi @Anonymous ,

Incremental refresh policies are defined in Power BI Desktop and applied when published to the Power BI service.

You need enable incremental refresh in Preview features first of all.

And click on the corresponding query table in Field pane, right click to choose Incremental refresh , enable the Incremental refresh and make some other settings.

For more detail steps, you can refer to Incremental refresh in Power BI Premium .

While the data type of the parameters must be date/time, it's possible to convert them to match the requirements of the datasource. For example, the following Power Query function converts a date/time value to resemble an integer surrogate key of the form yyyymmdd, which is common for data warehouses. The function can be called by the filter step.

(x as datetime) => Date.Year(x)*10000 + Date.Month(x)*100 + Date.Day(x)

What's more, there are some points you need considerate:

1.Incremental refresh is supported only for workspaces on Premium capacities. Refresh policies are defined in Power BI Desktop, and they are applied by refresh operations in the service.

2.If you're able to download the PBIX file containing an incremental-refresh policy from the Power BI service, it cannot be opened in Power BI Desktop. While this may be supported in the future, keep in mind these datasets can grow to be so     large that they are impractical to download and open on a typical desktop computer.

3.Currently, for composite models, incremental refresh is supported for SQL Server, Azure SQL Database, SQL Data Warehouse, Oracle, and Teradata data sources only.

4.Incremental Refresh is not supported for the connect live mode.

Best Regards,

Amy

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

[Anonymous]

Hi, 

If future visitor who facing the same problem as myself. 

Answer this before testing incremental support:

1. Where is your data source? Data source need to be 1 among these 5 only : SQL Server, Azure SQL Database, SQL Data Warehouse, Oracle, and Teradata

2. data column, which ll be applied parameter RangeStart RangeEnd needed to be data/time format

---

[v-xicai]

Hi  @Anonymous ,

Does that make sense? If so, kindly mark my answer as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.

Best regards

Amy

[v-xicai]

Hi @Anonymous ,

>>Hi, thanks for reply but my problem is the data is not folding properly even i did follow all required step. It ll fail at PBI service.

From your words, "the data is not folding properly" means the data is not filtered depending on the parameter RangeStart and RangeEnd correctly , right? Maybe you need to pay attention to the detail steps Incremental refresh in Power BI Premium .

Best Regards,

Amy