Posts

Showing posts from 2023

Excel Power Query - Nested JSON and never end Records

Image
From   Solved: Nested JSON and never end Records - Microsoft Fabric Community Nested JSON and never end Records ‎02-27-2017   06:43 PM Afternoon,   I have a json file ( https://1drv.ms/u/s!At8Q-ZbRnAj8hkJLL1cyU4t_hoHC ) which has many nested arrays and I'm unsure of how to extract all of the records into powerbi.   I've watch the guyinacube video (incredibly helpful), but I get to a point where I can't expand my columns any further yet I need the data inside that record (it's actually the data I want).   First step:  https://gyazo.com/86e411d5de9d7f2f52813f6f66cb3bf9 Convert to table, easy it converts out to this.   Second Step:  https://gyazo.com/546206f9a6b0459a4a09b2c865c3d902 Expand out, again comfortable. Expand again.   Third Step (issue):  https://gyazo.com/ffe36ce86fa91f4ae0a435c524d026e5 The column on the far right is the colum which contains the data that i want, but I'm unable to retrieve the data from that column without individually clicking on the link

Office 2016 - Enable Black theme and keep it from disappearing

From  Office 2016 - Enable Black theme and keep it from disappearing Solved - Windows 10 Forums (tenforums.com) (...) Well, just changing the entire Common folder to read-only ended up causing some other problems for me later - namely, Office would crash any time I tried to go to the File menu, or hit Ctrl+O to try to open a file, etc. I think there are some subkeys that office *needs* to be able to change or else it screws it up (recent file locations perhaps?). So I ended up setting the current key only (excluding subkeys) to read-only, while keeping full privileges for subkeys. I wrote a guide for some friends, so I'll paste the relevant steps here. Hope it helps! 1. In the registry editor, in the folder structure on the left, right-click Common and choose Permissions. 2. Near the bottom of the Permissions window, click “Advanced.” 3. Near the bottom, click “Disable Inheritance.” On the dialog that comes up, choose the first option: “Convert inherited permissions into explicit p

Setting Up a Free OpenVPN Server in Google Cloud Platform(GCP)

Image
From  Setting Up a Free OpenVPN Server in Google Cloud Platform(GCP) in Less Than 5 Minutes | by Raju Dawadi | Medium   Setting Up a Free OpenVPN Server in Google Cloud Platform(GCP) in Less Than 5 Minutes The VPN we are going to mention here: Is free : GCP provides  e2-micro  instance type for free on US region and we will be utilizing this along with free disk space and egress traffic Can be used for both internal and external traffic : Whether you want to connect to other GCP services or compute instances internally or route all of you computer’s traffic over the VPN, this way can be used Is limited to two active connections : In this specific post, we will walk through by using OpenVPN from marketplace which has limitation of 2 parallel users under free tier. In next post, we are going to show how this can be expanded Configurable through admin console : We can configure user account, vpn & network configuration, download ovpn file through web UI of OpenVPN Is very straight for

Items unpinned from taskbar are back after restart/sign out on Windows 10

 From  Items unpinned from taskbar are back after restart/sign out on Windows 10 - Super User Items unpinned from taskbar are back after restart/sign out on Windows 10 I have got a new installation of windows recently. Now when I do unpin items from taskbar that were there (IE, Edge, Explorer), they do come back after restart. A pinned chrome does not disappear though e.g. Anything to fix this issue? P.S. Just created a new user, and he has the same problem P.P.S. Sign out is enough to get it back, no full restart needed (...) I had the same problem. Nothing works. Finally, I found the XML file in my profile: %LOCALAPPDATA%\Microsoft\Windows\Shell\LayoutModification.xml The items were listed here in this section: </DefaultLayoutOverride> <CustomTaskbarLayoutCollection PinListPlacement="Replace"> <defaultlayout:TaskbarLayout> <taskbar:TaskbarPinList> -- items were here - removed </taskbar:TaskbarPinList> </defaultlayou