Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Incremental refresh with Large Data using Parameter_failure or not working properly

Hi All, i'm implementing incremental refresh one of dashboard which has around 400 million Data in single table, while implementing incremental refresh the initial load all the data will load afte...
Need Help
Tips and Tricks
  • mohitkumawat's avatar
    mohitkumawat
    2 years ago

    Hi Anonymous ,

    1. Whenever a Native query is disabled at the last applied steps.
    2. When applying the policy, ensure that the error mentioned below does not occur.

    3. Dev and Prod Parameters not work with incrementel Refresh because it Disable native query.
    4.  If your ingestion_date doesn't contain a column of Date/Time data type.

    Remove the Development and Production parameters. Adjust the Range Start and Range End dates to encompass the last 15 days based on your data. Load this modified dataset into Power BI Desktop and apply the necessary policies. See the screenshot below for reference.

    https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#create-parameters

     

mohitkumawat's avatar
mohitkumawat
Icon for Impactful Individual rankImpactful Individual
2 years ago

Hi Anonymous ,

1. Whenever a Native query is disabled at the last applied steps.
2. When applying the policy, ensure that the error mentioned below does not occur.

3. Dev and Prod Parameters not work with incrementel Refresh because it Disable native query.
4.  If your ingestion_date doesn't contain a column of Date/Time data type.

Remove the Development and Production parameters. Adjust the Range Start and Range End dates to encompass the last 15 days based on your data. Load this modified dataset into Power BI Desktop and apply the necessary policies. See the screenshot below for reference.

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#create-parameters