Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Adobe Analytics Connector Result Limits

So I see folks can only get up to 50,000 dimension values per call when pulling from the Adobe Analytics Connector. Is there a way you could somehow apply more than that? If so, how would one do that?

 

Currently I am using {Cube.ApplyParamater, "Top". (10000, "evar1")}

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

2 Replies

  • v-yinliw-msft's avatar
    v-yinliw-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Anonymous ,

     

    Unfortunately, Adobe Analytics has a built-in limit of 50 K rows returned per API call.

    So far there is no other way.

    For more information, you can refer this documentation:

    Power Query Adobe Analytics connector - Power Query | Microsoft Learn

     

    Hope this helps you.

     

    Best Regards,

    Community Support Team _Yinliw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • ReportGuru's avatar
    ReportGuru
    Icon for Post Patron rankPost Patron
    2 years ago

    The adobe connector and the Adobe API has this limit of 50,000 rows. As a workaround, if you wish to pull a larger amount of data, you can consider going from Adobe to BigQuery and then export to PBI, only then you won't face that limit the Adobe API has. I had to do it that way and I use windsor.ai to export directly from Adobe to BigQuery, and then going to PBI is pretty easy. Hope it helps