Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hi @mafaber ,
Please refer to this case please.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |