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.
() as table=>letWebCall = Web.Contents("http://intranetapi.com?request=serviceorders",[Timeout=#duration(0, 0, 30, 0), IsRetry=false]),Source = Json.Document(WebCall),#"Converted to Table" = Record.ToTable(Source)in#"Converted to Table"
letSource = SVCOrderFX(),Value = Source{0}[Value],#"Converted to Table" = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)in#"Converted to Table"
letSource = SVCOrderFX(),Value = Source{1}[Value],#"Converted to Table" = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error)in#"Converted to Table"
Solved! Go to Solution.
There is another method described here: Chris Webb's BI Blog: Speed Up Data Refresh Performance In Power BI Desktop Using Table.View Chris W...
that might be more reliable.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
There is another method described here: Chris Webb's BI Blog: Speed Up Data Refresh Performance In Power BI Desktop Using Table.View Chris W...
that might be more reliable.
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hello!
I have tried all of the mentioned in this thread solutions, but it doesn't work for me.
If I make a new API GET request of data then PQ makes 2 API calls instead of 1.
However, after I have received the data, if I repeat exactly the same query, then PQ makes 1 API call.
Please help, I am stuck.
While I no longer have the environment to test this, this is the correct answer.
Hi @tkboisvert
I can't find more solutions.
May @ImkeF take some time to analyze this problem?
Best Regards
Maggie
Hi @tkboisvert ,
don't know the reason for this either.
If no further answer is coming up here, I'd recommend to post your question in this forum instead: https://social.technet.microsoft.com/Forums/en-US/home?forum=powerquery
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Hi @tkboisvert ,
actually, there is a thing that you can try: Buffer the Web.Contents like so:
Binary.Buffer(Web.Contents(...
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
this worked for me for the same problem
Thanks Imke, it worked for me!
Will do! I'll report back.
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.