SPOL folder to dataflow

[mafaber]

Hi,

I'm trying to set up dataflows using SPOL files as datasources. What I do is I create the table in the desktop version then copy the M code from advanced editor to a blank query dataflow. It all works fine until I want to combine multiple files. Then I run into an error, even though Dataflows theoretically support SPOL folders based on https://docs.microsoft.com/en-us/power-bi/service-dataflows-data-sources#connecting-to-additional-da....

The error message is the following:

I'd really appreciate, if you could shine some light on what I do wrong.

[v-frfei-msft]

Hi @mafaber ,

Please refer to this case please.

https://community.powerbi.com/t5/Service/Dataflows-refresh-gives-error-about-AzureStorage-BlobConten...

[mafaber]

Hi @v-frfei-msft,

if I understand correctly, what I could use from that post is that I should check the credentials I use to access the datasource. But I think it's a different problem, individual files I can load without a problem from the same site, and I can also see the first few steps working while connecting to a list of files. The first step I see an error is the 'Removed other columns':

And after this step, the 'Expanded table columns' step results the error message I showed in the original post.

But still, I use no gateway and set up my credentials manually using the Windows Account I use for PBI and SPOL too.