PBI will not pull data from Azure Dev Ops

[BillyT_350]

Days. That's how long it takes me to refresh a few days of records from ADO. Days.

I can't even cancel a test refresh to free up my machine's resources.

Can query transformation steps be used with an ADO connection?

I need some help from MSFT devs to help figure out why PBI's ADO connectors do not work, and/or how to identify what the problem is and help me woth through it. I have not been able to find anything useful on the internet on the subject.

Thank you.

Note that I'm not actually pulling 26 weeks of data, that was just the name the original user gave the import. I set it to only be within the last 3 days.

[v-lili6-msft]

hi  @BillyT_350 

You may have a look this document:

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/data-connector-connect?view=azure-devop...

You may also create a support ticket for assistance from power bi support team if necessary.

Regards,

Lin

[BillyT_350]

@v-lili6-msft Thanks, but that article does not explain why my ADO connection is behaving so poorly. I found that, if just using steps like Source, Navigation, and Keep Columns steps, it seems to behave ok, albeit still with an abominably slow load rate; it's when I start doing things like date filtering and removing duplicates that it simpy ceases to work.

I will try filing a ticket, if I can get is associated with my company's premium support.