id765 adti3 8azzh 6zdt2 2era4 8efrn d3t9y k936i n5kan z6a3n 3kydn ibtts 8zfrz 44zry 86kh7 4645y ds72z h924s e3dnd 3e7kz shs6t Code works in Power Query, but fails when I try to "Close & Apply"? |

Code works in Power Query, but fails when I try to "Close & Apply"?

2021.10.19 14:37 MrHolte Code works in Power Query, but fails when I try to "Close & Apply"?

Code works in Power Query, but fails when I try to Good afternoon all,
Hoping you can help! I created the below code to call from the API which works perfectly in Power Query and I can see the results...
 let URL1 = "", Access = "ACCESSKEY", Secret = "SECRETKEY", Body = "{""include_unlicensed"": false,""num_assets"": 5000}", Header = "accessKey=" & Access & ";secretKey=" & Secret, Source1 = Json.Document(Web.Contents(URL1, [ Headers = [ #"X-ApiKeys" = Header ], Content = Text.ToBinary(Body) ] )), ExportUUID = Source1[export_uuid], URL2 = "" & Text.From(ExportUUID) & "/chunks/1", Source2 = Json.Document(Web.Contents(URL2, [ Headers = [ #"X-ApiKeys" = Header ] ] )), #"Converted to Table" = Table.FromList(Source2, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"asset", "output", "plugin", "port", "scan", "severity", "severity_id", "severity_default_id", "severity_modification_type", "first_found", "last_found", "state", "indexed"}, {"asset", "output", "plugin", "port", "scan", "severity", "severity_id", "severity_default_id", "severity_modification_type", "first_found", "last_found", "state", "indexed"}), #"Expanded asset" = Table.ExpandRecordColumn(#"Expanded Column1", "asset", {"agent_uuid", "hostname"}, {"agent_uuid", "hostname"}), #"Filtered Rows" = Table.SelectRows(#"Expanded asset", each ([severity_id] <> 0)) in #"Filtered Rows" 
This results in the below table in Power Query:
However, when I press "Close & Apply" to load it in to Power BI, I get the following error telling me it failed to get the contents:
Does anyone know why this would be happening? Took me ages to come up with the code and this should have been the "voila moment" but now it's just a new headache!
Any advice would be greatly appreciated.

Not sure if it makes a difference but this query returns 32,000 rows, which I've then filtered down to 1,150.
submitted by MrHolte to PowerBI [link] [comments]

2021.10.19 14:37 Crumbledupcookie A portrait for Peanut

A portrait for Peanut submitted by Crumbledupcookie to PaymoneyWubby [link] [comments]

2021.10.19 14:37 BrainstormBot 🗾 Hokkaido, Japan Region: 地震 - Earthquake (M5- estimated, at 12:36 UTC, from

地震 警報 / EARTHQUAKE WARNING for Hokkaido, Japan Region (just felt near Shizunai-furukawachō?) — Follow for updates (
submitted by BrainstormBot to EEW [link] [comments]

2021.10.19 14:37 night_howler_grt I think it's a good time now to adopt a puppy

I think it's a good time now to adopt a puppy submitted by night_howler_grt to aww [link] [comments]

2021.10.19 14:37 bagelgulper Mark Chesnutt yo

Mark Chesnutt yo submitted by bagelgulper to country [link] [comments]

2021.10.19 14:37 _justcass Tuesday night doodles ✨

Tuesday night doodles ✨ submitted by _justcass to doodles [link] [comments]

2021.10.19 14:37 Massive_Dinner 🔸▪️MiniBnb 🔸▪️| Stealth Launch 5 Minutes | Low Marketcap | Liquidity locked | Great Community 🦾

🔸▪️MiniBnb 🔸▪️| Stealth Launch 5 Minutes | Low Marketcap | Liquidity locked | Great Community 🦾
🔸Have you been looking for the next moonshot ? 🔥🔥🔥

After taking a look at many projects, I have found the one that I believe that will absolutely moon ! This will for sure be the moonshot of October.

✅ What is MiniBnb and ?

▪️MiniBnb is a redistributive token with a tiered giveaway strategy. Get redistributions in MiniBNB and get BNB in the tiered giveaway! The more MiniBNB you hold, the higher tier you will be in for a chance to win a BNB giveaway!

Hop in before it’s too late.

🔸A truly innovative project that is going to moon 100%.Hold your assets and get awesome returns ! 📈


💵4% Tax on every transaction

🔁 2% MiniBNB redistribution

📰 2% to Marketing

🔒Liquidity will be Locked

📑 Certik & Techrate Audits Incoming

📍 No staking, HODL to earn 💰

🚀 100x potential

✅ How will the team increase the tokens value ?

▪️The team will do explosive marketing. Lots of promotions like Poocoin Ads and promotions with huge influencers. With a clear end goal of reaching a 1B market cap within the first couple of months after launch.

Contract : 0xc5f8ba43978e1970355dde9e3655e84633e43b2d

Buy :


🗳 Telegram :

💻 Website : ( COMING SOON )
submitted by Massive_Dinner to CryptoMoon [link] [comments]

2021.10.19 14:37 MyTootsiesAreWet What are some good bass cabs and heads for a decent price?

submitted by MyTootsiesAreWet to BassGuitar [link] [comments]

2021.10.19 14:37 Throwaway1heheh Me and my bf had a fight. I caught my mum talking to him in a room when i chucked him out

This is the second time shes done this. Actually both my parents did this at the beginning. None of them checked up on me but they checked up on him. After last night when he called me a stupid bitch and really hurt me physically (put both arms around me and squeezed as hard as he could). I told him to get his stuff today. I found them talking alone in a room when he was getting his stuff and i went downstairs. I fucking hate them both. I need to move out asap
submitted by Throwaway1heheh to narcissisticparents [link] [comments]

2021.10.19 14:37 Company-Motor All we have are each other

Fuck others
Ape MF army
submitted by Company-Motor to amcstock [link] [comments]

2021.10.19 14:37 Analyticsinsight01 How Does Data Analytics Help in Smart City Development?

How Does Data Analytics Help in Smart City Development? submitted by Analyticsinsight01 to dataanalyst [link] [comments]

2021.10.19 14:37 pageantcircle Miss Universe Colombia 2021 is Valeria Ayos

Miss Universe Colombia 2021 is Valeria Ayos submitted by pageantcircle to pageantcircle [link] [comments]

2021.10.19 14:37 InfusionTea Having Hōjicha and peanut mochi tonight!

Having Hōjicha and peanut mochi tonight! submitted by InfusionTea to tea [link] [comments]

2021.10.19 14:37 xo3yk Nice restaurants for a big party in southside! What are your reccomendations?

My 21st is coming up, I would love to hear your favourite restaurants for a party of 15? Or any other recommendations?
submitted by xo3yk to brisbane [link] [comments]

2021.10.19 14:37 lrxvjj am i being gaslit?

am i being gaslit?
room mate has made it apparent through his non verbal behaviour he doesn’t like me and the other flatmate, so we decided to have an open convo about it.
he said he wants to move, because he intimidate him and make him uncomfortable.
we apologised, and asked for an example of this behaviour, and what can we do to change this so we don’t continue to make him feel this way.
he said ‘i don’t know, i need to figure it out’
he then was talking about moving out ASAP, so we asked for some advice from a friends family member who’s a landlord, we came back to him and talked about his options our options etc, he then said ‘don’t do anything quickly because i might stay instead’
feel like i’m going crazy and it’s triggering a lot of bpd symptoms tonight, help
[reposting in this sub as the other BPD sub, no one answered and i really need some outside perspective]
submitted by lrxvjj to BorderlinePDisorder [link] [comments]

2021.10.19 14:37 The_10th_Woman Week 42: One Pot - Chicken stew. Very hearty and satisfying.

submitted by The_10th_Woman to 52weeksofcooking [link] [comments]

2021.10.19 14:37 Dima1043 I'm 15 and I have never hugged a girl in my life.

Hi :)
submitted by Dima1043 to teenagers [link] [comments]

2021.10.19 14:37 Specific-Pea2293 WG commision

submitted by Specific-Pea2293 to meme [link] [comments]

2021.10.19 14:37 Bloodexxx "I'll stab you *****" personal art made by me, oc is mine, halfbody commissions are 15$

submitted by Bloodexxx to furry [link] [comments]

2021.10.19 14:37 sleeper_001 Hey nux try doing a Collab with this guy

Hey nux try doing a Collab with this guy submitted by sleeper_001 to NuxTakuSubmissions [link] [comments]

2021.10.19 14:37 NEU_Throwaway1 28 cases later… finally found me some gasser soup

28 cases later… finally found me some gasser soup submitted by NEU_Throwaway1 to HotWheels [link] [comments]

2021.10.19 14:37 Ueberu-san Got a couple o' shrooms here I found in Wirral, UK that need identifying, if anyone would be so kind

Got a couple o' shrooms here I found in Wirral, UK that need identifying, if anyone would be so kind submitted by Ueberu-san to ShroomID [link] [comments]

2021.10.19 14:37 bam1007 TEPSLF Trophies!

This morning, I was greeted with the joyous trophies and an updated count with a slight miscalculation on six payments on my loans but all the other 160+ of my post-10/2007 payments counted (under TEPSLF, not the PSLF waiver).
Here’s my timeline:
7/12/2021 - Applied 7/22/2021 - Employment accepted, transfer process begins 8/20/2021 - Transferred loan information appears on Fedloan. 8/23/2021 - welcome packet appears on website; preliminary payment count appears on website and is wrong (111/120). Only goes back to 4/2012 (likely when ACS transferred to my prior provider, Ed financial); contact Fedloan and explain that my count should be from 10/2007 and this may be because of ACS, offer to provide them with full payment history from Ed financial (which Ed financial was very happy to provide me). Opted into CARES forbearance and played ping pong with service providers over who refunds me (it was Fedloan who was supposed to). Told I needed to wait dor my CARES forbearance to go into effect before requesting a refund. 8/24 -CARES forbearance goes into effect 8/25 - Called Fedloan to check on review because of ACS. advised that a refund is not necessary for CARES effect on IDR since 4/2020 to be in effect. 8/26 - requested refund of CARES payments (didn’t know I was TEPSLF eligible when I made them) 9/2 - made PA request of DOE for all documents related to ACS administration of loans, still in progress 9/22 - contacted Office of Consumer Advocacy with payment history over the 54 uncredited payments, response tells me to wait until 10/25 to complain more 9/29 - notified by Student Aid that I have the wrong EIN on one of my employers, immediately send in another ECF with the EIN they want (don’t ask why…it’s bizarre) 10/18 - See CARES refund being processed because loan balance increases by amount of refund 10/19 - TEPSLF trophies! Count off by 6 on one loan, so email sent to consumer advocacy.
Hopefully, the slight miscount will be corrected quickly and this will finally be done!
Thank you to Betsy and everyone else in this sub for your pleasant and helpful advice and support in this process.
submitted by bam1007 to PSLF [link] [comments]

2021.10.19 14:37 Kerfluffle2x4 Most insufferable client you’ve ever had?

At the end of the day, we’re part of a service industry, maybe not what people first think of when they hear that’s moniker, but legal services are services all the same. As a result, we’ve all had our fair share of annoying, litigious, dumb, and nasty clients. And, since /talesfromthecourt doesn’t have nearly the same amount of traction as this sub, I was wondering if anyone had some good stories to share here.
submitted by Kerfluffle2x4 to Lawyertalk [link] [comments]

2021.10.19 14:37 gwagon69 Anybody Disappointed in their Interview Season So Far?

It’s all in the title. Any current residents willing to share success stories are more than welcome.
submitted by gwagon69 to medicalschool [link] [comments]