Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I am at the very beginning as PowerBI user. I try the incremental recfresh on a sample of my data provided by Adobe Analytics source
= Cube.Transform(myreportsuitename,
{
{Cube.ApplyParameter, "DateRange", {#date(2022, 1, 3), #date(2022, 1, 16)}},
{Cube.AddAndExpandDimensionColumn, "DateGranularity", {"year", "month", "day"}, {"Date Granularity.Level 1: Year", "Date Granularity.Level 2: Month", "Date Granularity.Level 3: Day"}},
{Cube.AddAndExpandDimensionColumn, "prop2", {"prop2"}, {"Custom Insight 2"}},
{Cube.AddAndExpandDimensionColumn, "mobiledevicetype", {"mobiledevicetype"}, {"Device Type"}},
{Cube.AddAndExpandDimensionColumn, "prop25", {"prop25"}, {"Groupe"}},
{Cube.AddAndExpandDimensionColumn, "page", {"page"}, {"Page"}},
{Cube.AddMeasureColumn, "Visits", "visits"},
{Cube.ApplyParameter, "Segment", {{"s1951_61432c91f2d98f38f410dafc"}}}
})
I made the data column
= Table.AddColumn(#"Éléments ajoutés", "Date_trafic", each #date([#"Date Granularity.Level 1: Year"],[#"Date Granularity.Level 2: Month"],[#"Date Granularity.Level 3: Day"]))
and the parameters, filtered, published
= Table.AddColumn(#"Éléments ajoutés", "Date_trafic", each #date([#"Date Granularity.Level 1: Year"],[#"Date Granularity.Level 2: Month"],[#"Date Granularity.Level 3: Day"]))
But though I can see the parameters, the incremental refresh is not active : the message I can see is about the parameters to set up.
Can you help ? Is this feature is avalaible for Pro users ?
Thank you !
Maria
Solved! Go to Solution.
Hi. The feature is still for pro. The problem to keep in mind is that in the feature considerations you can read that the feature was built to work with sources that can apply query folding. Adobe analytics might not fold.
However the community has proved to avoid that limitations for some sources like sharepoint.
I think this can help you because it is the first time I have seen a person able to build an incremental refresh from a non foldable source.
https://www.esbrina-ba.com/incrementally-load-from-sap-apis-or-almost-anything/
I hope that helps,
Happy to help!
Hi. The feature is still for pro. The problem to keep in mind is that in the feature considerations you can read that the feature was built to work with sources that can apply query folding. Adobe analytics might not fold.
However the community has proved to avoid that limitations for some sources like sharepoint.
I think this can help you because it is the first time I have seen a person able to build an incremental refresh from a non foldable source.
https://www.esbrina-ba.com/incrementally-load-from-sap-apis-or-almost-anything/
I hope that helps,
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.