User Profile
VitalieCiobanu
MCT
Joined 8 years ago
User Widgets
Recent Discussions
Re: WiFi in Win11 issues in .3915
As of this morning, the issue got fixed by itself. No new version of Windows installed since yesterday, when it was 100% not working. No updates besides defender definitions, so not sure what the issue was and how it was fixed and by whom... E.T. playing around maybe :)78Views0likes0CommentsWiFi in Win11 issues in .3915
So i'm going crazy here and don't know where to go next, to Microsoft support or my internet provider... I've happily had Hyper-V on my Windows 11 Insider and some VMs i use for delivering trainings. Few days ago i noticed i no longer can connect to the internet on the VMs. Existing VMs, new VMs, VMs with past snapshots applied, etc.... no internet on the VMs, period. I tried creating new switches several times and nothing helps. However, although i don't need internet to deliver the trainings, when doing so at the university, i always use my host/laptop's internal card with a SIM in it and have no issues whatsoever with the internet in VMs. The SIM i have is from the same provider as my home cable is from. I just turned off my WiFi and connected the cellular network. Boom! VMs instantly have internet access. Turning on WiFi -> no internet again. So at this point i'm kind of stuck and not sure where to go for help. Obviously there is nothing wrong with my Windows OS in general, but there is an issue with the WiFi. On the host, i have no issues with the WiFi, internet is fine and working properly. I'm shutting down my laptop every night, so "restarting" did not fix it. Should i try resetting my router or go to Microsoft Windows support first? I think going to the internet provider has no benefit now, as they will blame the OS. Any thoughts?Export licensing information
Hello, Besides Graph, PowerShell or manual export, is there another way to export all licenses (Admin Center > Billing > Licenses) and associated users for each product? We need this data weekly, hence the need to get the data in a more automated way. Unfortunately I'm not able to use PowerShell or Graph.993Views0likes0CommentsRe: O365 licensing datasource?
Hi Grzesiek, Besides Graph and manual export, is there another way to export all licenses for each product and users using these licenses? We need this data weekly in order to connect it with our internal data for some specific dashboards. Thank you.2.3KViews0likes4CommentsRe: Tablas dinamicas
Hola Martin, Lo siento, no estoy seguro de entender lo que quieres lograr... ¿Desea concatenar el valor de texto respectivo y la hora en una celda? La foto adjunta tiene un ejemplo de cómo hacerlo. Si no, envía un ejemplo de Excel o un dibujo con lo que quieras hacer.1.8KViews0likes0CommentsRe: OneDrive Files On-Demand For The Enterprise
Well, if all your files have same columns, maybe Power Query can help you get around "opening each file" issue. You can import each file separately or you can combine them into one worksheet, if that's ok for what you need. https://www.youtube.com/watch?v=ldoQws7Zbx8 https://www.youtube.com/watch?v=a7E29H5ZUmE1.3KViews0likes1CommentData Quality history
Hi guys, I would need some help with an easy data import. I have a table with some history data in it, imported during certain dates (Snapshot_Date). Some fields in the table are blank at certain import dates and then populated with data. I would like to check this data quality in some way. For example, 1.png is a sample table with bogus data. Upon inserting new data into the table tomorrow, for example, I'd like an IF statement (or some other way) that will check if Address field is null, see 2.png. If Address is null, then add FAILED in the Check_Address field. If Address is not null, then add PASSED in the Check_Address field. To insert data into the history table, I'm using a View that gets data from a table with current data, I'm adding GETDATE() that will become Snapshot_Date and that's it. I tried using IF/Else and Case in my View, but looks like I'm missing something...Solved1.2KViews0likes1CommentRe: Excel
Excel only allows a limited number of nested IF statements. If you have too many options to check, maybe its better to consider VLOOKUP instead. See here for more info. https://support.office.com/en-us/article/if-function-%E2%80%93-nested-formulas-and-avoiding-pitfalls-0b22ff44-f149-44ba-aeb5-4ef99da241c8685Views0likes0CommentsRe: Text colour formatting
Looks like you need Conditional Formatting. This will get you started https://support.office.com/en-us/article/Enter-and-format-data-fef13169-0a84-4b92-a5ab-d856b0d7c1f7#ID0EAABAAA=Conditional_formatting If you still can't work it out, come back here and someone will definitely help you.1KViews0likes0CommentsRe: Connecting Excel to SQL Server 2017
As far as I can see, using SQL Management Studio you are connecting to a server name that has one R letter but in Excel, you have two R letters in TIRREL. If you are connecting fine from SQL Management Studio, then your hostname only contains one R.11KViews0likes2CommentsRe: OneDrive Files On-Demand For The Enterprise
Ok, don't know if I got it right... So you want D30 to have file name and selected tab changed dynamically when you select different values in your C4 and C5 list values? What is $C$6 in D30? Anyway, if this is close to what you want, here's what I did. Because I don't know if your file names on SharePoint will be of same length, I'm getting file name only in column E using flash fill. So I ended up having File1 to File12 in E14 to E25. Next, changed D5 vlookup to =IFERROR(VLOOKUP(C5,C14:E25,3,FALSE)," ") to include E column with file names and display file name in D5. Now, in D30 put =CONCAT("[",D5,"]",C4,"!",$C$6). Again, don't know what that C6 is, because that cell is blank in your file.1.3KViews0likes3Comments
Recent Blog Articles
No content to show