Hi - I am building out a Power BI dashboard by pulling in data from Adobe Analytics using the native connector that's provided. When retrieving the data by selecting the desired dimensions and measures, it's fetching only 10 records (be advised that it's not even top 10 when I cross checked). I did some Google research and understood that I need to change the M-code to 50000 which is the max capacity and changed the code to show top 50000.
This seems to have resolved the issue on the surface. However, when I add granularity, let's say day level granularity it's again showing me only 10 records (Not top 10 records) when compared to Adobe Analytics.
Basically, before changing the code, it was restricting to 10 records at an overall level. Now, it's able to show me greater than 10 records but when granularity is added it's again restricting to showing 10 records at each specified granularity. Any expert advice on this would be much appreciated on how to bypass this.
For the same level of granularity/dimension I am able to see 1,000+ records in Adobe Analytics Webpage. Below is the modified M-code for reference. Connection details change to retain privacy.
Modified M-code below:
let
Source = AdobeAnalytics.Cubes([HierarchicalNavigation=true]),
#"Source" = Source{[Name="Name"]}[Data],
companyname.prod.esntls = #"company group"{[Id="companyname.prod.esntls"]}[Data],
#"Added Items" = Cube.Transform(companyname.prod.esntls,
{
{Cube.ApplyParameter, "Top", {50000, "eVar 01}, "DateRange", {#date(2022, 1, 1), #date(2022, 12, 31)}},
{Cube.AddAndExpandDimensionColumn, "DateGranularity", {"year", "month"}, {"Date Granularity.Level 1: Year", "Date Granularity.Level 2: Month"}},
{Cube.AddAndExpandDimensionColumn, "evar1", {"evar1"}, {"(eVar 01) Page URL"}},
{Cube.AddMeasureColumn, "Visits", "visits"}
}),
TopRows = Table.FirstN(#"Added Items", 50000)
in
#"Added Items"
