Schedule change for My AI Learning path to success with Microsoft: Certifications, Skills, and Community

Hi Adedapo,

The schedule for this event has changed. The updated date and time are below.

My AI Learning path to success with Microsoft: Certifications, Skills, and Community

Mon, Oct 28, 2024 9:30 AM – 10:00 AM (UTC-07:00) Pacific Time (US & Canada)

We apologize for any inconvenience and hope you’ll still be able to join us.

Sincerely,

Jorge Maia

What will the time be in West African time?

I checked online and saw different answers, because there is daylight pacific time which is different from US and Canada time, plus US has different time zones.

Also the UTC-07:00 is that the ending time or the beginning time?

The timing was not this ambiguous the last time it was rescheduled. They just included the calender file and my calender application converted the time automatically for me. 

​Schedule change for My AI Learning path to success with Microsoft: Certifications, Skills, and Community Hi Adedapo,The schedule for this event has changed. The updated date and time are below.My AI Learning path to success with Microsoft: Certifications, Skills, and CommunityMon, Oct 28, 2024 9:30 AM – 10:00 AM (UTC-07:00) Pacific Time (US & Canada) We apologize for any inconvenience and hope you’ll still be able to join us. Sincerely,Jorge Maia What will the time be in West African time? I checked online and saw different answers, because there is daylight pacific time which is different from US and Canada time, plus US has different time zones. Also the UTC-07:00 is that the ending time or the beginning time? The timing was not this ambiguous the last time it was rescheduled. They just included the calender file and my calender application converted the time automatically for me.   Read More

​

I’m trying to create a script that should create an exchange receive connector from a CSV file that contains the list of the connectors to create as well as some properties.

The problem is not the creation of the connector, which we can create from the csv, but the “remoteiprange” properties that throw an error.

The csv file has this format

“Name”,”Bindings”,”DeliveryStatusNotificationEnabled”,”AdminDisplayName”,”RemoteIPRanges”,”PermissionGroups”
“TestConn”,”0.0.0.0:25″,”True”,””,”192.168.101.0/23 192.168.102.0/23″,”AnonymousUsers, ExchangeServers, Custom”

So we read all the parameters from the file and try to create the new connector passing them to the command but the error we get is 

New-ReceiveConnector : Cannot bind parameter ‘RemoteIPRanges’. Cannot convert value “192.168.101.0/23,192.168.102.0/23” to type “Microsoft.Exchange.Data.IPRange”. Error: “The format of the IP address
192.168.101.0/23,192.168.102.0 is invalid. Example of a valid IP address: 192.168.1.10″

​I’m trying to create a script that should create an exchange receive connector from a CSV file that contains the list of the connectors to create as well as some properties.The problem is not the creation of the connector, which we can create from the csv, but the “remoteiprange” properties that throw an error.The csv file has this format”Name”,”Bindings”,”DeliveryStatusNotificationEnabled”,”AdminDisplayName”,”RemoteIPRanges”,”PermissionGroups””TestConn”,”0.0.0.0:25″,”True”,””,”192.168.101.0/23 192.168.102.0/23″,”AnonymousUsers, ExchangeServers, Custom” So we read all the parameters from the file and try to create the new connector passing them to the command but the error we get is New-ReceiveConnector : Cannot bind parameter ‘RemoteIPRanges’. Cannot convert value “192.168.101.0/23,192.168.102.0/23” to type “Microsoft.Exchange.Data.IPRange”. Error: “The format of the IP address192.168.101.0/23,192.168.102.0 is invalid. Example of a valid IP address: 192.168.1.10”  Read More

​

I’m trying to create a script that should create an exchange receive connector from a CSV file that contains the list of the connectors to create as well as some properties.

The problem is not the creation of the connector, which we can create from the csv, but the “remoteiprange” properties that throw an error.

The csv file has this format

“Name”,”Bindings”,”DeliveryStatusNotificationEnabled”,”AdminDisplayName”,”RemoteIPRanges”,”PermissionGroups”
“TestConn”,”0.0.0.0:25″,”True”,””,”192.168.101.0/23 192.168.102.0/23″,”AnonymousUsers, ExchangeServers, Custom”

So we read all the parameters from the file and try to create the new connector passing them to the command but the error we get is 

New-ReceiveConnector : Cannot bind parameter ‘RemoteIPRanges’. Cannot convert value “192.168.101.0/23,192.168.102.0/23” to type “Microsoft.Exchange.Data.IPRange”. Error: “The format of the IP address
192.168.101.0/23,192.168.102.0 is invalid. Example of a valid IP address: 192.168.1.10″

​I’m trying to create a script that should create an exchange receive connector from a CSV file that contains the list of the connectors to create as well as some properties.The problem is not the creation of the connector, which we can create from the csv, but the “remoteiprange” properties that throw an error.The csv file has this format”Name”,”Bindings”,”DeliveryStatusNotificationEnabled”,”AdminDisplayName”,”RemoteIPRanges”,”PermissionGroups””TestConn”,”0.0.0.0:25″,”True”,””,”192.168.101.0/23 192.168.102.0/23″,”AnonymousUsers, ExchangeServers, Custom” So we read all the parameters from the file and try to create the new connector passing them to the command but the error we get is New-ReceiveConnector : Cannot bind parameter ‘RemoteIPRanges’. Cannot convert value “192.168.101.0/23,192.168.102.0/23” to type “Microsoft.Exchange.Data.IPRange”. Error: “The format of the IP address192.168.101.0/23,192.168.102.0 is invalid. Example of a valid IP address: 192.168.1.10”  Read More

​

We’re looking for Microsoft Fabric data engineers to take our new beta exam. Do you have subject matter expertise in data loading patterns, data architectures, and orchestration processes? If so, and if you’re responsible for ingesting and transforming data, securing and managing an analytics solution, and monitoring and optimizing an analytics solution, be sure to check out this exam.

If this is your skill set, we have a new Microsoft Certification for you. The Microsoft Certified: Fabric Data Engineer Associate Certification validates your expertise in this area and offers you the opportunity to prove your skills. To earn this Certification, pass Exam DP-700: Implementing Data Engineering Solutions Using Microsoft Fabric, currently in beta.

Is this the right Certification for you?

This Certification could be a great fit if you have subject matter expertise with data loading patterns, data architectures, and orchestration processes. Responsibilities for this role include:

Ingesting and transforming data.
Securing and managing an analytics solution.
Monitoring and optimizing an analytics solution.

You should work closely with analytics engineers, architects, analysts, and administrators to design and deploy data engineering solutions for analytics.

You should be skilled at manipulating and transforming data by using Structured Query Language (SQL), PySpark, and Kusto Query Language (KQL).

Ready to prove your skills?

Take advantage of the discounted beta exam offer. The first 300 people who take Exam DP-700 (beta) on or before November 12, 2024, can get 80 percent off market price.

To receive the discount, when you register for the exam and are prompted for payment, use code DP700Covington. This is not a private access code. The seats are offered on a first-come, first-served basis. As noted, you must take the exam on or before November 12, 2024. Please note that this beta exam is not available in Turkey, Pakistan, India, or China.

Get ready to take Exam DP-700 (beta):

Review the Exam DP-700 (beta) exam page for details. The Exam DP-700 study guide alerts you to key topics covered on the exam.
Work through the Get ready for the new Fabric Data Engineer Associate Certification Official Collection of curated content to help you get ready.
For additional information, explore our Microsoft Learn Blog post Prove your data engineering skills and join the AI transformation.
Want even more in-depth training? Connect with Microsoft Training Services Partners in your area for in-person offerings.
Need other preparation ideas? Check out my blog post Just How Does One Prepare for Beta Exams?

Did you know that you can take any role-based exam online? Online delivered exams—taken from your home or office—can be less hassle, less stress, and even less worry than traveling to a test center, especially if you’re adequately prepared for what to expect. To find out more, read my blog post Online proctored exams: What to expect and how to prepare.

The rescore process starts on the day an exam goes live, and final scores for beta exams are released approximately 10 days after that. For details on the timing of beta exam rescoring and results, check out my post Creating high-quality exams: The path from beta to live.

Ready to get started?

Remember, the number of spots to advantage of the discounted beta exam offer is limited to the first 300 candidates taking Exam DP-700 (beta) on or before November 12, 2024.

​Microsoft Tech Community – Latest Blogs –Read More 

Greetings Tech Community! As the Director of Product Marketing for Microsoft 365 Copilot for SMBs, I live and breathe efficiency. Every day is a mix of strategy, content creation, data analysis, project management and collaboration. My team is small and mighty. We work like a fast-paced startup, and just like the small businesses we serve, we’re passionate about making a big impact with lean resources. 

Recently, Copilot in Loop has become my secret tool to stay on top of it all. With the latest capabilities announced in September, I’ve found even more ways to streamline my workflows while keeping things organized and collaborative. 

Here are my top three tips and tricks to help you get the most out of your day: 

Let’s Craft a Winning Presentation: Ignite 2024 Prep! 

One of the biggest tasks on my plate right now is preparing for my session at Ignite 2024! With Copilot’s private chat in Loop, I can brainstorm session ideas and create outlines without interrupting my team’s workflow. This helps me organize my thoughts and draft the structure of my presentation.

With Copilot’s help, I get a clear starting point that saves me time and helps me build a high-quality narrative for my session.

Growing Reach and Engagement: Getting Ready for Customer-Facing Webinars

We’ve just landed the Forrester’s New Technology: Projected Total Economic Impact of Microsoft 365 Copilot for SMB study, and my team is gearing up to present the eye-opening findings at an Microsoft Technical Community webinar on October 31 (make sure to tune in!). My goal? Coaching my team to effectively communicate the best practices for Copilot adoption that demonstrate real business value. This is where Copilot in Loop steps in to help me brainstorm ideas that will resonate with SMBs.

This allows me to quickly gather impactful content, which I can then tweak to make sure it hits home with SMB audiences.

Turning Feedback into Action: Organizing Partner Insights

I’m an avid note-taker and after last week’s partner meetings, I now need to organize all the inputs and share it with the product teams. With multiple data points to manage, I’m going to turn to Copilot in Loop to structure everything clearly so I can turn feedback into actionable insights.

This streamlines the process, helping me provide clear, actionable recommendations to our product teams.

​Microsoft Tech Community – Latest Blogs –Read More 

This guide shows you how to configure a Windows 10 PC as a kiosk for running Windows App, which is now generally available on Windows, macOS, iOS, iPadOS, web, and in public preview for Android. This will give users an experience similar to Windows 365 Boot, where the sole purpose is to connect users to their primary device: a Cloud PC.

As more organizations use Windows 365 Cloud PCs as their primary Windows desktop experience, they want to reduce the complexity of configuring the client device, the physical endpoint. To address that, we introduced Windows 365 Boot, which became generally available last year. This feature is often used to repurpose the devices customers already have, but Windows 365 Boot is built to work exclusively on Windows 11.

In December 2023, we announced that Extended Security Updates (ESUs) will be included with Windows 365 subscriptions for Windows 10 devices that access Windows 365 at no additional cost. Although support for Windows 10 will end on October 14, 2025, devices with ESU will continue to receive security updates for up to three years. We strongly recommend migrating to a new Windows 11 PC with all the great security features turned on by default to keep your organization protected and productive. However, there may be circumstances that prevent replacing devices that are ineligible for Windows 11 before the end-of-support date. If you cannot upgrade to Windows 11 using Windows Autopatch or Microsoft Intune, you might consider using Windows 11 on a Cloud PC.

A Cloud PC lets your workers securely access applications and documents from anywhere in the world, but they need to connect from a client device. Using a Windows device just to open Windows App to then sign in to a Cloud PC can be an awkward and time-consuming effort, and the user may be tempted to work from the client instead of the Cloud PC. That creates the opportunity to configure the Windows 10 device as a kiosk, so it is easy and quick for the user to sign in to their Windows 365 Cloud PC directly from that kiosk device.

Cloud PC kiosk configuration

To configure a Cloud PC kiosk with Windows 10 Pro or Enterprise, you will need:

Windows App – installed from the Microsoft Store or via MSIX
Microsoft Edge WebView2 – installed via PowerShell or Win32 package
AssignedAccess – a CSP to configure the kiosk

Here, we’ll use Microsoft Intune to install and configure these to give you a working kiosk as a starting point. You can then modify the configuration to meet your needs.

We’ll also use a new Microsoft Entra security group called Cloud PC kiosks throughout this example. Members of the group should be the Windows 10 devices that are to be configured as a kiosk.

While it’s out of scope for this guide, it is best to provision these as Microsoft Entra joined devices using Windows Autopilot. You could use a user-driven or self-deploying mode, whichever you prefer.

Install Windows App

You’ll need to install Windows App on the device in system context that allows any user to run the application. The easiest way to do this is by adding it from the Microsoft Store. You could also download the MSIX package from the What’s new in Windows App page. To use the line-of-business application, you’ll need the VCLibs.140.00 it depends on.

Search for and select Windows App and select the UWP published by Microsoft Corp. Then set Install behavior to System.

Finally, assign the app to the Cloud PC Kiosks group as a Required installation.

Install WebView2

Windows App requires WebView2 which is not preinstalled on Windows 10. Since the kiosk configuration prevents the dynamic install of WebView2, we’ll use a PowerShell script to download and install WebView2, also in the system context, using the Evergreen Standalone Installer. This will always get the latest version of WebView2, and it will update automatically. If you prefer, you could create a Win32 package for the installer.

Download the Get-UpdatedWebView2.ps1 script from GitHub, and be sure it is encoded using UTF-8. If you copied the raw text into Notepad, use Save as to set the encoding type.

In the Intune admin center, go to Devices | Windows > Windows | Scripts and remediations. Then from the Platform scripts tab, select Add. Name it something like Cloud PC Kiosk – Install WebView2 and select the script you just saved. Set Run this script using the logged on credentials to No, Enforce script signature check to No, and Run in 64 bit PowerShell Host to Yes.

Then, assign the script to the same Cloud PC Kiosks group and finish adding the script.

Create custom kiosk policy

Use a custom profile to create the kiosk configuration. This gives you the most flexibility in how your kiosk works and is defined entirely in XML. From Intune, create a new Policy, for Platform select Windows 10 and later, for Profile type select Templates, then select Custom.

When prompted for a name use something like Cloud PC Kiosk Dedicated Mode and when prompted for configuration settings, select Add to provide details for the Open Mobile Alliance Uniform Resource Identifier (OMA-URI) settings as described in the table below.

Name

Kiosk for Each User

Description

Each user will get the Kiosk experience with Windows App and Settings

OMA-URI

./Vendor/MSFT/AssignedAccess/Configuration

Type

String

Value

<?xml version=”1.0″ encoding=”utf-8″?>

<AssignedAccessConfiguration xmlns:xs=”http://www.w3.org/2001/XMLSchema ” xmlns=”http://schemas.microsoft.com/AssignedAccess/2017/config ” xmlns:default=”http://schemas.microsoft.com/AssignedAccess/2017/config ” xmlns:rs5=”http://schemas.microsoft.com/AssignedAccess/201810/config ” xmlns:v3=”http://schemas.microsoft.com/AssignedAccess/2020/config “>

 <Profiles>

  <Profile Id=”{9A2A490F-10F6-4764-974A-43B19E722C23}”>

   <AllAppsList>

    <AllowedApps>

     <App AppUserModelId=”MicrosoftCorporationII.Windows365_8wekyb3d8bbwe!Windows365″ rs5:AutoLaunch=”true” />

     <App AppUserModelId=”windows.immersivecontrolpanel_cw5n1h2txyewy!microsoft.windows.immersivecontrolpanel” />

    </AllowedApps>

   </AllAppsList>

   <StartLayout><![CDATA[

          <LayoutModificationTemplate xmlns:defaultlayout=”http://schemas.microsoft.com/Start/2014/FullDefaultLayout ” xmlns:start=”http://schemas.microsoft.com/Start/2014/StartLayout ” Version=”1″ xmlns=”http://schemas.microsoft.com/Start/2014/LayoutModification “>

            <LayoutOptions StartTileGroupCellWidth=”6″ />

            <DefaultLayoutOverride>

            <StartLayoutCollection>

              <defaultlayout:StartLayout GroupCellWidth=”6″>

              <start:Group Name=””>

               <start:Tile Size=”4×4″ Column=”0″ Row=”0″ AppUserModelID=”MicrosoftCorporationII.Windows365_8wekyb3d8bbwe!Windows365″ />

               <start:Tile Size=”2×2″ Column=”0″ Row=”5″ AppUserModelID=”windows.immersivecontrolpanel_cw5n1h2txyewy!microsoft.windows.immersivecontrolpanel” />

              </start:Group>

              </defaultlayout:StartLayout>

            </StartLayoutCollection>

            </DefaultLayoutOverride>

          </LayoutModificationTemplate>

        ]]></StartLayout>

   <Taskbar ShowTaskbar=”false” />

  </Profile>

 </Profiles>

 <Configs>

  <v3:GlobalProfile Id=”{9A2A490F-10F6-4764-974A-43B19E722C23}”/>

 </Configs>

</AssignedAccessConfiguration>

This will use the Windows 10 AssignedAccess CSP, which automatically configures a variety of things for your kiosk, including some AppLocker settings that will lock down the kiosk to only allow running the applications that are defined in the AllowedApps section. In this example, only two applications are allowed:

Windows App – used to connect to Windows 365 Cloud PCs, Microsoft Dev Box machines, and Azure Virtual Desktop session hosts. It’s also set to start automatically when the user signs into the kiosk.
Settings – used to access Network/Wi-Fi settings, Bluetooth pairing, system information, and more.

There are endless variations you can adjust to your preferences, but to wrap up this example, assign this policy to the Cloud PC Kiosks group. Once the policy is applied and you sign in, your kiosk should look like this:

Later you can revise this XML to add other applications. Just be sure to add them to the AllowedApps so they can run, and to the StartLayoutCollection so users can see them.

For example, if you wanted to add the Edge browser, add these two lines in their respective sections:

<AllowedApps>

<App AppUserModelId=”%ProgramFiles(x86)%MicrosoftEdgeApplicationmsedge.exe” />

<start:Group Name=””>

<start:DesktopApplicationTile Size=”2×2″ Column=”2″ Row=”5″ DesktopApplicationLinkPath=”%ALLUSERSPROFILE%MicrosoftWindowsStart MenuProgramsMicrosoft Edge.lnk” />

And the kiosk will now look like this:

You can also control the parts of Settings that users can access with the PageVisibilityList policy.

Additional kiosk settings

Although they aren’t required, here are some additional modifications that may yield a better experience. These examples use a custom CSP, but you can find most of them in the settings catalog as well.

Name

Enable Kiosk Status for MDM

Description

Enables Intune to query status of the Kiosk App

OMA-URI

./Vendor/MSFT/AssignedAccess/StatusConfiguration

Type

String

Value

<StatusConfiguration xmlns=”http://schemas.microsoft.com/AssignedAccess/2018/StatusConfiguration “>

<StatusEnabled>OnWithAlerts</StatusEnabled>

</StatusConfiguration>

Name

Disable First Sign-in Animation

Description

Expedites logon times of new users

OMA-URI

./Vendor/MSFT/Policy/Config/WindowsLogon/EnableFirstLogonAnimation

Type

Integer

Value

0

Name

Disable User ESP

Description

Expedites provisioning and logon times by not waiting for user assignments

OMA-URI

./Vendor/MSFT/DMClient/Provider/MS DM Server/FirstSyncStatus/SkipUserStatusPage

Type

Boolean

Value

True

Name

Show Local Users on Lock Screen

Description

Show the Kiosk User on the lock screen to switch between User and Kiosk accounts

OMA-URI

./Vendor/MSFT/Policy/Config/WindowsLogon/EnumerateLocalUsersOnDomainJoinedComputers

Type

String

Value

<enabled />

Name

Display Network Selection UI on Lock Screen

Description

Shows the Network Connection menu on the logon screen

OMA-URI

./Vendor/MSFT/Policy/Config/WindowsLogon/DontDisplayNetworkSelectionUI

Type

String

Value

<disabled />

Of course, there are countless settings you might consider such as setting an image on the lock screen or the wallpaper or other suggestions for boot devices.

Troubleshooting

To test the kiosk configuration, add a Windows 10 device that is Microsoft Entra ID joined to the group where the configurations have been assigned. Then restart, or if you’re using Windows Autopilot, wipe it to go through provisioning. Once the policies are applied and installations are complete, you’ll be prompted to sign in. After doing so, you should see the kiosk springboard, Windows App should load, and you’ll be ready to connect to your Cloud PC.

Look in the logs

If something isn’t working, you can use Intune to collect diagnostics and review the log files and event logs to investigate errors that need to be addressed.

Some helpful areas to look at include those in the table below:

Event log

Microsoft/Windows/AppLocker/EXE_and_DLL

Event log

Microsoft/Windows/AssignedAccess/Operational

Registry

HKLMSoftwareMicrosoftWindowsAssignedAccessConfiguration

Registry

HKLMSoftwareMicrosoftWindowsAssignedAccessCsp

Log files

C:ProgramDataMicrosoftIntuneManagementExtensionLogs

You can also review the kiosk mode troubleshooting guide.

If WebView2 is not installed

Windows 10 does not have WebView2 installed by default. When running Windows App, users may be prompted to install WebView2, which they will not be able to do on an AssignedAccess kiosk.

To resolve this, use Intune to install WebView2 in the system context. Earlier in this guide, we described how to do that using a PowerShell script.

If Windows Defender Firewall blocks Microsoft Teams

When Teams runs on the Cloud PC and uses media optimizations, an attempt is made to create an Allow rule in Windows Defender Firewall on the local kiosk. Since the user is not an admin on the kiosk, they are unable to allow this action and perpetually get prompted for credentials.

To resolve this, use Intune to preconfigure a firewall rule that will allow Windows App to accept the incoming Teams media for all users on the kiosk, so they are not prompted.

Create a new Template profile using the Endpoint protection type and name it something like Cloud PC Kiosk Firewall Settings. Find Windows Firewall, add a new rule to allow inbound connections for the Teams app using these settings.

Name

Allow Teams App Inbound

Direction

Inbound

Action

Allow

Network Type

Domain, Private and Public

Application

File Path

File path

%USERPROFILE%AppDataLocalMicrosoftTeamscurrentteams.exe

Then, assign it to the Cloud PC Kiosks group and finish creating the policy.

Wrapping up

We hope you find this guide helpful for your transition to Windows 11 and Windows 365! Learn more about ESUs and how Windows 365 users can get them at no additional cost in this episode of Windows in the Cloud with Mark Florida and Michael Raschko.

Continue the conversation. Find best practices. Bookmark the Windows Tech Community, then follow us @MSWindowsITPro on X and on LinkedIn. Looking for support? Visit Windows on Microsoft Q&A.

​Microsoft Tech Community – Latest Blogs –Read More 

Recently we announced the new updated V2 of our Popular Snowflake Connector in Azure Data Factory. The new connector promises better performance and security. The new V2 Connector supports the Pipelines and Data Flows and comes with the new Go-based Snowflake driver.

Differences between the Legacy and V2 Connector

The V2 connector comes with enhancement in terms of performance and security. The following are the major differences between legacy and V2 Connector.

Snowflake (V2)

Snowflake (legacy)

ODBC Driver

Go Driver

Support Basic and Key pair authentication.

Support Basic authentication.

Script parameters are not supported in Script activity currently. As an alternative, utilize dynamic expressions for script parameters.

Support script parameters in Script activity.

Support BigDecimal in Lookup activity. The NUMBER type, as defined in Snowflake, will be displayed as a string in Lookup activity.

BigDecimal is not supported in Lookup activity.

Connection Parameters include Account, Warehouse, Database, Schema, and Role

Connection Parameter is Connection String

Additional Connection Properties are not supported

Additional Connection Properties are Supported

Only Password / Keypair keys can be stored in KeyVault

Passwords and Connection Strings can be stored in KeyVault

The V2 version offers several enhancements over the legacy version including Autoscaling, Multi-Availability, Static IP, support for enhanced Storage Integration and upcoming features like Iceberg support.  Find more information on the Connector Docs.

Deprecation of Legacy Connector

The Snowflake Legacy Connector will have the End of Support by Oct 31st, 2024, in end of support, the connector is considered as deprecated, and no longer supported.  Customers are advised to upgrade the Connector to the new V2 Connector to continue using the connector and experience the new enhanced features. Read the official announcement to know more.

Migrating from Legacy to V2 Connector

The steps required to update from legacy to V2 Connector involve the following process.

Check if Script Parameters are being used.

If so modify them to use dynamic expressions

Check if Additional Connection Parameters are being used

If so, those parameters cannot be applied to the new Connector

Update the Linked Service to V2 Connector
Update the Dataset to V2 Dataset

Updating the Linked Service:

Here is a typical example of Linked Services using Parameters and Basic Authentication.

LegacyV2

The Version of the Connector needs to be changed to V2
The Type Properties should be updated to include the following from the connection String

“typeProperties”: {
“authenticationType”: “Basic”,
“accountIdentifier”: “@{linkedService().accountIdentifier}”,
“user”: “@{linkedService().user}”,
“database”: “@{linkedService().database}”,
“warehouse”: “@{linkedService().warehouse}”,
“encryptedCredential”: “<encrypted_credential_value>”
}

Updating the Dataset:

The Dataset needs to be updated to include the V2 of the Connector. Update the Property Type from SnowflakeTable to SnowflakeV2Table.

Updating the Definition files:

The Linked Service and the Dataset can be updated through Git. The following steps can be used to update the Linked Service.

Create a new Branch from the Main Branch
Update the Definition Files
Test out the Connection and the Pipelines
Give a Pull-request and merge it with the Main branch

All the other branches should pull in from this branch or make manual changes to their branch to match the definition.

Gathering the list of Data Factories with Legacy Connector:

If you have a large environment and need to find the list of Data Factories that use the Legacy Connector, you can do so by using PowerShell. Please note that this program will run for a long time based on the number of resources.

You can access the code in this Gist.

Validating with Snowflake Query History:

The queries generated by the Data Factory users can be validated in Snowflake to check whether it is generating from Legacy or the V2 Connector.

SELECT DISTINCT CLIENT_APPLICATION_ID, USER_NAME
FROM SNOWFLAKE.ACCOUNT_USAGE.SESSIONS
WHERE CREATED_ON > DATEADD(DAY, -1, CURRENT_TIMESTAMP) // OPTIONAL: FILTER BY TIME
AND USER_NAME = ‘<ADF_USER>’ // THE USER THAT IS CONFIGURED IN DATA FACTORY
ORDER BY CLIENT_APPLICATION_ID;

The Legacy Connector will have “ODBC” followed by the version and the V2 connector will have “GO” followed by the version. To just check for the connections coming in from ODBC, you can filter on the client_application_id column.

SELECT DISTINCT CLIENT_APPLICATION_ID, USER_NAME
FROM SNOWFLAKE.ACCOUNT_USAGE.SESSIONS
WHERE CREATED_ON > DATEADD(DAY, -1, CURRENT_TIMESTAMP) // OPTIONAL: FILTER BY TIME
AND USER_NAME = ‘<ADF_USER>’ // THE USER THAT IS CONFIGURED IN DATA FACTORY
AND CLIENT_APPLICATION_ID LIKE ‘%ODBC%’ // FILTER BY ODBC FOR LEGACY CONNECTOR
ORDER BY CLIENT_APPLICATION_ID;

Best Practices:

The following best practices can be applied to the Data Factory so that the migration of the connector can be easier.

Use Git for version control with the Data Factory
Create a separate branch to manage just Linked Services without any Pipelines / Artifacts so that it can be merged with the main branch and other branches
Update the Username / Password based authentication to KeyPair Authentication for enhanced security
Use Key Vault for storing the Passwords / Keypair keys
Test out the connector in a specific dev environment / branch before pushing to the main branch

We hope you will use the new and improved connector. If you have any issues or next help with the migration, please reach out to your Microsoft Account team.

​Microsoft Tech Community – Latest Blogs –Read More 

​Good day, I need your assistance and guidance in building a workflow that will take data from a SharePoint list and transfer it to a third-party service desk system to log a change request. Here is my flow and where it’s failing:    Read More

​

Hello everyone,

Some of you may remember my previous thread about the same-ish issue (https://techcommunity.microsoft.com/t5/project/excel-reporting-can-t-connect-to-calendars-with-odata-anymore/m-p/4132119) that ended up being solved by a Project Online patch.

But somehow, the issue returned. Not the same cause, since it has nothing to do with authentication this time, but the same symptoms : trying to fetch Calendar Exceptions data from an Excel OData query doesn’t work anymore.

When trying to get the data, I am getting “Error 400 : Cannot get a CSOM-compatible PJContext for an HTTP request that started outside of CSOM.”

It seems the issue started this morning on my client’s tenant.

Has anyone else experienced the same issue ?

​Hello everyone,Some of you may remember my previous thread about the same-ish issue (https://techcommunity.microsoft.com/t5/project/excel-reporting-can-t-connect-to-calendars-with-odata-anymore/m-p/4132119) that ended up being solved by a Project Online patch. But somehow, the issue returned. Not the same cause, since it has nothing to do with authentication this time, but the same symptoms : trying to fetch Calendar Exceptions data from an Excel OData query doesn’t work anymore. When trying to get the data, I am getting “Error 400 : Cannot get a CSOM-compatible PJContext for an HTTP request that started outside of CSOM.” It seems the issue started this morning on my client’s tenant.Has anyone else experienced the same issue ?  Read More

​

Dear experts,

Please put me out of my misery.  After a long process of pulling data from a PDF to put into Excel, I now have 2 tabs of data. It was beautiful and served the purposes initially explained.  Since then, more requirements have surfaced and I also need to track status. 

I’m providing an simplified example to protect the sensitivity of the real data.  

Offices tab

OfficeAsset Set112231

Assets tab

Asset SetAssetDescriptionDelivery DateDelivered?1L-shaped DeskIkea 1003  1Ergo ChairWayfair 40  1BookshelfIkea 502  2Basic DeskWalmart 20-7474  2Basic ChairWalmart 20-9348  2

Bookshelf

Ikea 502

Data is in a single Excel worksheet. One tab contains all the offices in a building. The second tab contains the breakdown of items that belong in that office. I made sure to have the Asset number relationship in the tabs because I’m pulling this data into a different format for use elsewhere.

(Side note: the items that make up an asset set could exist in another asset set.; see Bookshelf) 

I add 2 new columns in the Assets tab for Delivery info since I need to know whether the item was delivered to the office, for all items, for all offices. 

I can do the Index Match formula to find the Asset Set value in the Offices tab but I couldn’t find any way to select all the rows in the Asset tab, Copy, and Insert Copied Rows under that referenced row on the Offices tab. 😕  I don’t know VBA or Macros except to copy and tweak.

I have 1000 rows in the Assets tab and 300 rows in the Offices tab.  I really really don’t want to do this manually if I can avoid it.  I’ll need to do this as more office buildings get updated equipment.

In the meantime, I will start this process manually;

Create a new tabCopy Office row, paste into new sheetCopy group of rows from Asset tabpaste under office row (starting at column B to preserve the column heading detail)Rinse and repeat.

I hope someone has an amazing solution. Thanks in advance for your brain.

​Dear experts,Please put me out of my misery.  After a long process of pulling data from a PDF to put into Excel, I now have 2 tabs of data. It was beautiful and served the purposes initially explained.  Since then, more requirements have surfaced and I also need to track status.  I’m providing an simplified example to protect the sensitivity of the real data.   Offices tabOfficeAsset Set112231 Assets tabAsset SetAssetDescriptionDelivery DateDelivered?1L-shaped DeskIkea 1003  1Ergo ChairWayfair 40  1BookshelfIkea 502  2Basic DeskWalmart 20-7474  2Basic ChairWalmart 20-9348  2BookshelfIkea 502   Data is in a single Excel worksheet. One tab contains all the offices in a building. The second tab contains the breakdown of items that belong in that office. I made sure to have the Asset number relationship in the tabs because I’m pulling this data into a different format for use elsewhere.(Side note: the items that make up an asset set could exist in another asset set.; see Bookshelf)  I add 2 new columns in the Assets tab for Delivery info since I need to know whether the item was delivered to the office, for all items, for all offices.  I can do the Index Match formula to find the Asset Set value in the Offices tab but I couldn’t find any way to select all the rows in the Asset tab, Copy, and Insert Copied Rows under that referenced row on the Offices tab. 😕  I don’t know VBA or Macros except to copy and tweak. I have 1000 rows in the Assets tab and 300 rows in the Offices tab.  I really really don’t want to do this manually if I can avoid it.  I’ll need to do this as more office buildings get updated equipment. In the meantime, I will start this process manually;Create a new tabCopy Office row, paste into new sheetCopy group of rows from Asset tabpaste under office row (starting at column B to preserve the column heading detail)Rinse and repeat. I hope someone has an amazing solution. Thanks in advance for your brain.    Read More

​