Adobe analytics not working in Data marts

[gaganmeet13]

I have been trying to connect adobe analytics data to Power BI in data marts but I cant seem to get any data whatsoever. It works perfectly fine when connected via innbuilt Adobe analytics connector but I wish to do it in Data marts to speed up the work and use incremental refresh.

I would really appreciate som help.

[v-xiaoyan-msft]

Hi @gaganmeet13 ,

We have not received any feedback from other users who have had similar experiences to yours.

Only a subset of Power Query operations that support Query folding are currently supported.

Please check if you have meet this.

Best regards.
Community Support Team_ Caitlyn

[RM7]

@gaganmeet13 Don't know what the problem can be but maybe you can export your Adobe data through a 3rd party connector. I've never done it using Data Mart but I have used windsor.ai and funnel.io connectors and both work well. I stayed with windsor because it's much cheaper than funnel and you can also use incremental refresh. If you still have the same issue with Data Mart, you can test your data with one of this connectors and see if it works. To make the connection, first you have to search for the Adobe connector among the list of datasources:

Then, you should enter your Adobe credentials to make the connection. After that, you'll see a preview of your data where you can select the fields you want to see in PBI. 

Finally, you just have to choose PBI as destination and copy and paste the url that will appear there in PBI desktop --> Get Data --Web > --> Paste the link