Forum Discussion
Csv.Document(Web.Contents("abc"),[Delimiter=",", Columns=3, .. take hours
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 ??
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
Hi, PakAli
To resolve slow processing with Csv.Document(Web.Contents(...)) in Power Query:
- Check File & Network: Test file size and download speed outside Power Query.
- Disable Background Preview: Go to File > Options > Data Load and disable Allow data preview in the background.
- Optimize Web.Contents: Use headers or authentication tokens:Web.Contents("https://...", [Headers=[Authorization="Bearer TOKEN"]])
- Download Locally: Temporarily save the file locally and test performance.
- Check File & Network: Test file size and download speed outside Power Query.
6 Replies
- PwerQueryKees
Super User
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
rohit1991Hi, PakAli
To resolve slow processing with Csv.Document(Web.Contents(...)) in Power Query:
- Check File & Network: Test file size and download speed outside Power Query.
- Disable Background Preview: Go to File > Options > Data Load and disable Allow data preview in the background.
- Optimize Web.Contents: Use headers or authentication tokens:Web.Contents("https://...", [Headers=[Authorization="Bearer TOKEN"]])
- Download Locally: Temporarily save the file locally and test performance.
- Check File & Network: Test file size and download speed outside Power Query.
- Chewdata
Responsive Resident
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]
v-prasareCommunity Support
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.
- 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.
