Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn more

View all

Sign in to view all badges

PowerBI Desktop / Adobe Analytics Connector - Date Granularity Issue

alexjbaker11
Level 2
Level 2

Hi All,

 

When using PowerBi with the 2.0 (Beta) implementation for analytics, whenever I try to add "Year" from "Date Granularity" I am getting this error which seems to be saying that "Year" is a string (I can't see a method to change this either): 

 

alexjbaker11_1-1623168215095.png

 

Has anyone encountered this before?

 

 

3 Replies
Mathewson86
Level 1
Level 1

I encounter a similar problem. Is there any workaround for this?

gmaranga
Level 1
Level 1
this should absolutely be fixed and should be part of the MVP, the 2.0 API is useless without it and shouldn't even be released in a beta without it
gmaranga
Level 1
Level 1

If you have "day of year" as a dimension you can leverage that with YTD (or whatever period you need) segmentation applied.  You'll have to also build a fiscal calendar table to link "day of year" with an actual date. 

This worked on my end but it was very time consuming and doesn't feel like the most stable solution out there.