Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi!
So, I'm using this newest version of Power BI and somehow I'm not being abble to use date hierarchy.
My Data is from Marketo's REST API.
let
// Get Url from config worksheet - Table REST_API_Authentication
mktoUrlStr = "XXXXXXXXXXXXXXXXXXXXXXXXXX",
// Get the List id - Table Scoping
listIdStr = "XXXXXXXXXXXXXXXXXX",
// Get the Lead fields to extract - Table Leads
leadFieldsStr = "id, firstName,lastName,email,createdAt,UpdatedAt",
// Build Multiple Leads by List Id URL
getMultipleLeadsByListIdUrl = mktoUrlStr & "/rest/v1/list/" & listIdStr & "/leads.json?fields=" & leadFieldsStr,
// Build Marketo Access Token URL parameter
accessTokenParamStr = "&access_token=" & FnMktoGetAccessToken(),
// No initial paging token required for this call
pagingTokenParamStr = "",
// Invoke the multiple REST API calls through the FnMktoGetPagedData function
result = FnMktoGetPagedData (getMultipleLeadsByListIdUrl , accessTokenParamStr, pagingTokenParamStr),
convertedTable = Table.FromList(result, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
formatedTable = if Table.IsEmpty(convertedTable) then result else FnMktoFormatLead(convertedTable),
#"Tipo Alterado" = Table.TransformColumnTypes(formatedTable,{{"createdAt", type datetime}})
in
#"Tipo Alterado"
The column createdAt is in type = datetime and still the date hierarchy it's not available.
I'm using version 2.61.5192.601
Solved! Go to Solution.
In that file's options, under Data Load, is "Auto Date/Time" unchecked? That will disable automatic hierarchies.
You can manually create them by right-clicking on the date, New Heirarchy, then drag in the other pieces you need (day, month, whatever).
I prefer doing that as I don't like the auto-date/time stuff. I want to manually control my date table.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingIn that file's options, under Data Load, is "Auto Date/Time" unchecked? That will disable automatic hierarchies.
You can manually create them by right-clicking on the date, New Heirarchy, then drag in the other pieces you need (day, month, whatever).
I prefer doing that as I don't like the auto-date/time stuff. I want to manually control my date table.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThat's it!
Thank you for the reply and thank you for the alternative it's really better than enabling this Auto Date/Time.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |