Data Flows Using Google Drive Are Having Problems

[seanpratt]

I keep getting this error message today and have zero idea what to do. I've read the blog post that's frequently linked to from here for disabling the load, but I've had 2017, 2018, and 2019 all using this code so that didn't have any impact. The issue is that it happened when I tried to create 2020 and now 2019 is broken too. I'm just been spinning in circles today trying to navigate different potential solutions with no luck.

[Greg_Deckler]

Could be TSIS (Temporary Service Insanity Syndrome. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[seanpratt]

I reached out to Support and they tell me that Dynamic functions are no longer compatible with Data Flows...

This wasn't always the case though, right? Or am I just setting up the new one wrong. Would three "invoke custom function" steps be considered dynamic functions? I find it hard to believe they just regressed in functionality.

[v-alq-msft]

Hi, @seanpratt 

Here are considerations and limitations with dataflows mentioned in the official document.

• A dataflow must output one of the following types: Date/Time, Decimal Number, Text, Whole number, Date/Time/Zone, True/False, Date, Time
• Dynamic functions are currently not supported within dataflows

For furhter information, please refer to the document . 

Best Regards

Allan

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

[seanpratt]

Hi @v-alq-msft ,

Yes, - that's the response I got from support. My question is... did they used to be though? I used the exact same query steps from 2017-2019 without issue and yesterday it errorred out and now all of them are