Forum Discussion
Connect to API in Power Query - Error: Block length does not match with its complement.
I wrote a blog post with two solutions to this problem here:
https://blog.crossjoin.co.uk/2023/02/05/the-block-length-does-not-match-with-its-complement-error-in-power-query-in-power-bi-and-excel/Chris
Apart from the obvious names, many of whom aren't active these days, I really like Rick de Groot's content (https://gorilla.bi/power-query/) and I learn a lot from Ben Gribaudo's blog (https://bengribaudo.com/)
Hi Chris, I just read your 2 blogs RE "dynamic what-if", excellent as usual. My question: is there a direct option in PQ to switch Import/DQ, instead of going back to PBI? On several occassions I meant for DQ, but ended up importing, there is no way to go back once it's imported in PBI. Sorry I meant to post on your blog, but Akismet kept blocking me.