Csv.Document(Web.Contents("abc"),[Delimiter=",", Columns=3, .. take hours

[PakAli]

Hi

I am been googling and searching around

but could not find any answer, request your guidance

several of datasources .. simple but take hours to complet

Csv.Document(Web.Contents("abc"),[Delimiter=",", Columns=3, Encoding=1252, QuoteStyle=QuoteStyle.Csv])

The file is not that big, but I am not sure what is happening
I wonder if there is any log or anything to understand what is happening ??

[PwerQueryKees · Accepted solution]

What happens if you hit Retry?
If it gives the same error, do a refresh all previews.

Give it some time! Just wait until it is finished.

If that doesn't work, share any error message, you get in any query: You will see the orange warning icon on queries with possible issues. Open the queries, readd the error message if any. If the error message refers to another queries, open that one.

Did I answer your question? Then please mark my post as the solution and make it easier to find for others having a similar problem.
If I helped you, please click on the Thumbs Up to give Kudos.

Kees Stolker

A big fan of Power Query and Excel

[v-prasare]

@PakAli, as we haven’t heard back from you, we wanted to kindly follow up to check if the solution we have provided for your issue worked? or let us know if you need any further assistance here?

Your feedback is important to us, Looking forward to your response. 

Thanks,

Prashanth Are

MS Fabric community support.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query.

[v-prasare]

@PakAli, as we haven’t heard back from you, we wanted to kindly follow up to check if the solution we have provided for your issue worked? or let us know if you need any further assistance here?

Your feedback is important to us, Looking forward to your response. 

Thanks,

Prashanth Are

MS Fabric community support.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query.

[v-prasare]

hi @PakAli,

Hope your doing well.

@Chewdata, @rohit1991, @PwerQueryKees thanks for your prompt answers

@PakAli, as we haven’t heard back from you, we wanted to kindly follow up to check if the solution we have provided for your issue worked? or let us know if you need any further assistance here?

Your feedback is important to us, Looking forward to your response. 

Thanks,

Prashanth Are

MS Fabric community support.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query.

[Chewdata]

Hey! 

Sometimes it helps to:

•  Just click close and apply (make sure that enable load is checked)
• click refresh preview on previous steps in the query, such as source, promote headers, etc.
• add CsvStyle=CsvStyle.QuotesAfterDelimiter to the options part: [Delimiter=",", Columns=3,  Encoding=1252, CsvStyle=CsvStyle.QuotesAfterDelimiter]

[rohit1991 · Accepted solution]

Hi, @PakAli 

To resolve slow processing with Csv.Document(Web.Contents(...)) in Power Query:

1. Check File & Network: Test file size and download speed outside Power Query.
   
   
2. Disable Background Preview: Go to File > Options > Data Load and disable Allow data preview in the background.
   
   
3. Optimize Web.Contents: Use headers or authentication tokens:Web.Contents("https://...", [Headers=[Authorization="Bearer TOKEN"]])
   
   
4. Download Locally: Temporarily save the file locally and test performance.

[PwerQueryKees · Accepted solution]

What happens if you hit Retry?
If it gives the same error, do a refresh all previews.

Give it some time! Just wait until it is finished.

If that doesn't work, share any error message, you get in any query: You will see the orange warning icon on queries with possible issues. Open the queries, readd the error message if any. If the error message refers to another queries, open that one.

Did I answer your question? Then please mark my post as the solution and make it easier to find for others having a similar problem.
If I helped you, please click on the Thumbs Up to give Kudos.

Kees Stolker

A big fan of Power Query and Excel