Unanswered

Creating CSV from Power Query - No Data?

(0) Share

Report

Posted on by phil-romano

Hi all,

I am trying to create a flow that will generate a CSV from a Power Query. The flow processes without error but it is not writing any data to the file. Any help would be appreciated.

Here is the flow:

Flow

Here is the result:

Result

Thank you

Phil

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Hi @phil-romano

With the screenshot you have provided for the result we can see that the input to the CSV table is empty [], therefore the output will be too. What we need to be exploring now is the history of the output for both the PowerQuery and Initialize Variable actions as one if not both will be empty and you need to understand why. Looking at the history will help understand this and then I will be able to help you - hopefully.

Damien

Was this reply helpful? Yes No
phil-romano 13 on at

Like (0)

Report

It looks like the Power Query component is throwing an error:

{
"resultType": "Exception",
"message": "An error happened while reading data from the provider: 'Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.'",
"details": null,
"errors": [],
"evaluationUsage": null
}

Was this reply helpful? Yes No
Verified answer

phil-romano 13 on at

Like (1)

Report

I disabled loading of the relationship columns and it worked. Thank you!

Was this reply helpful? Yes No