Token Comma Expected Error
I am very very new to Power Query and have managed to get this written with some help up until the last comma error. I do not know how to even troubleshoot this. Can someone help me figure out how to get this working please. let Source =…

Learning about Azure, guide seems old.
Hi everybody, I have been following this guide/module about Azure functions, and there is a tip talking about you may need to use an old (classic it says) experience to follow the instructions. Actually, I am not able to find such option, I know the…
Domain Admin Access not working
We recently hired a new domain admin and after setting up his account he is not able to log into any of our domain controllers nor is his credentials working to join computers to the domain. The following is the error he receives when trying to log into…
Permisisons to troubleshoot Mic and Speaker
How to grant domain users permissions to troubleshoot MIC and Speaker issues or settings ? I can't find a GPO for that
Multiple accounts for SAML
We are implementing SSO through SAML and we have several applications that have accounts for both single users and groups. Is there a way to configure accounts in Azure SAML to accommodate both of these options?
Example of simple Containment vs Base Containment
The Legacy CE model assumes that users always query for data that exists. This means that, for a join predicate that involves an equijoin operation for two tables, the joined columns exist on both sides of the join. In the presence of additional non-join…

HELP: Insert data into SQL table ERROR: Conversion failed when converting date and/or time from character string. ()
Hi, i need to insert data into a SQL database, but i have some problems, can you help me?? SqlCommand cmd = new SqlCommand(); cmd.Parameters.Add("@Batch_ID", SqlDbType.NVarChar, 50).Value = Batch_ID; …

Unable to forward ports n a Windows VM.
Port forwarding is not working ob my Windows vm. I have tried adding multiple inbound ports, the only port open by default was 3389 for rdp all others are closed. even http

Stored procedure connects to linked server but generates report with error
• All the stored procedures are on server X. The Stored Procedure 1 calls 4 subordinate reports, aggregating the results from each into a table variable, @finalResults. • The subordinate stored procedures are: o Stored Procedure 2 (server…

change datatype in a table
Hi, I want to change dataType from int to varchar for columns MakeID,ModelID.vahicleTypeID Reason is sometimes we get the data as string. As this table is already in Production, we just need to modify the datatype of the columns. How easy is this doing…

Azure function architecture design for large enterprise
I am trying to create an integration layer between our client applications and external API's. This integration layer is to be serverless and designed in Azure function. I know when we are working with API there are numerous architecture to follow…
Lock Screen Image GPO for Windows 10 - Microsoft Best practice
Lock Screen Image through GPO for Windows 10. , What would be UNC path to be used to have Lock Screen Image as per Microsoft Best practice.
Azure File Share Auditing
Hi, Is there a way to enable audit log for Azure File Share as in a typical Windows File Server? Are there any other ways to see who has modified/deleted/created a file? My File Storage is AD joined. Thanks! Warmly, Michal
Execute Stored Procedures stored in table
Hi Team - I have a main stored procedure that runs daily and this main procedure executes all the procedures in it. I have set up the main procedure in the SQL agent job. Below is how the main procedure is designed: Create Procedure…
Microsoft Forms don´t show up in Teams
Hello, I have created different types of forms in Forms which I then upload to a Sharepoint page and then pal to use in Teams. The problem is that when my team members look at the forms they can not see them. They get an error message saying that they…
Following Account Upgrade, cannot use Batch. Advice on how to resolve AccountEncryptionKeyUnavailable?
I recently upgraded my subscription from Azure Students to Pay-As-You go. However, I am unable to use my batch account to create pools or jobs. An error (summarized below) is returned stating that the Account Encryption key is unavailable. This…
SVG to DataTemplate not working which as PathGeometry
I have 3 Country Flags in SVG , I need to Convert SVG to DataTemplate. Example : France Flag , this is Working <DataTemplate x:Key="France"> <Grid HorizontalAlignment="Stretch"> <Path…

Linked Service with ADF Connection Failing
I am attempting to connect by Azure Data Lake Analytics account with Azure Data Factory via a Linked Service. I have added the required information in the Edit linked service blade, created an app and a secret for the Service Principal ID and key, set…
Issues with EXCEL subtotal using vb.net
I am getting random Grand Totals when I use vb.Net to sub-total the spreadsheet: The code I am using is: enter code herePublic Function SubTotalBudgetSummary(ixlsxWorkSheet As Excel.Worksheet) As Boolean Dim lexcelRange As Object = Nothing …
Automate Maintenance jobs in Azure SQL Database
Hi Team, I am planning to implement Index maintenance job on 5 Azure SQL Db's Options: Using Rubook Elastic Jobs feature. My question is ,which option is best for cost ($$$) point of view?