Forum Discussion

gbhoosamRavi's avatar
gbhoosamRavi
New Member
2 years ago

Query on Pulling Multi-Dimension Reports at Day Granularity Using Adobe Analytics 2.0 in Power BI

Hello Power BI Community, I'm currently facing a challenge with the Adobe Analytics 2.0 connector in Power BI. My goal is to pull multi-dimensional reports at a day granularity for a year-to-date (Y...
Need Help
Show and Tell
Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
2 years ago

Hello gbhoosamRavi,

 

1. Adobe Analytics 2.0 Connector should theoretically support pulling multi-dimensional reports. However, the complexity increases when adding more dimensions and granularity, especially at a day level over a long period like YTD (Adobe might have limitations on the amount of data that can be fetched in a single query)

 

2. High data volume can lead to long processing times (and timeouts) as this is expected due to the amount of data being processed. 

  • If possible, consider pulling the data at a higher level of granularity (e.g., weekly or monthly) and then breaking it down into daily granularity.
  • It may also be worthwile implementing incremental data loading.
  • Also, instead of pulling all dimensions in a single query, maybe consider splitting them up and combining the data in Power BI.

Hope this helps - If you require any questions or further assistance, please do not hesitate to reach out to me.