Hi,
I am using power bi to create some charts for over 300 analytics accounts all in one.
I am using a custom function to get this ( i use a method from curbal youtube)
I can access the accounts and it pulls in the data but I am only getting the last two months of data.
If i do individual accounts without the custom funcion. I get the full data ( from July 2023 ) But when i do all of them or more than one I only get two months.
Is this just data sampling because of the size of the query ? - anyone have any idea how I can get around it ?
CUSTOM FUNCTION :
let Multiple =(AccountId as text,PropertyId as text,PropertyId2 as text)=>
let
Source = GoogleAnalytics.Accounts([Implementation="2.0"]),
Account = Source{[Id=AccountId]}[Data],
Property = Account{[Id=PropertyId]}[Data],
Property2 = Property{[Id=PropertyId2]}[Data],
#"Added Items" = Cube.Transform(Property2,
//You have to susbstitute this part with a your new query (dimensions, metrics) and create a new function for each query. Just create the query as a simple table and copy it here.
{
{Cube.AddAndExpandDimensionColumn, "date", {"date"}, {"date"}},
{Cube.AddAndExpandDimensionColumn, "eventName", {"eventName"}, {"eventName"}},
{Cube.AddAndExpandDimensionColumn, "firstUserSourceMedium", {"firstUserSourceMedium"}, {"firstUserSourceMedium"}},
{Cube.AddAndExpandDimensionColumn, "pagePath", {"pagePath"}, {"pagePath"}},
{Cube.AddAndExpandDimensionColumn, "pageTitle", {"pageTitle"}, {"pageTitle"}},
{Cube.AddMeasureColumn, "conversions", "conversions"},
{Cube.AddMeasureColumn, "sessions", "sessions"},
{Cube.AddMeasureColumn, "totalUsers", "totalUsers"},
{Cube.AddAndExpandDimensionColumn, "dateHourMinute", {"dateHourMinute"}, {"dateHourMinute"}}
})
in
#"Added Items"
in Multiple
