John Liu Blog

Every drop counts

Power Automate with Excel

When we work with Excel in Power Automate, we might need to remove the filter on worksheet to be able to create a data table. If filter is enabled, Excel Online for Business connector might not be able to create a data table. We can create Office Script within Excel Online for Business. To save the script so Power Automate can use it, we must open the file in Excel Online (the web version).

Posted by John Liu Friday, February 13, 2026

SQL 2025 Gotcha

SQL 2025 is GA and SQL 2016 is on it’s end of life on Jul 14, 2026. Some changes in SQL 2025 might break things working before. SQL 2025 uses MSOLEDBSQL 19, and its defaults are different from what we have been using, like with old SQL Native Client (SQLNCLI). In SQL 2025, encrypt is on by default, trust server certification is off by default, and it enforces strick certificate chain validation.

Posted by John Liu Monday, February 9, 2026

Fabric Capacity

When we use paid Fabric Capacity, we might need to auto pause and resume the capacity for cost saving. We can use Azure Automation Runbook to achieve this. We setp an Automation Account with a Managed Idenity. Step 1: Set Up Permissions Go to your Azure Automation Account. Under Account Settings, click Identity and ensure the “System assigned” toggle is On. Go to your Fabric Capacity resource in the Azure Portal.

Posted by John Liu Friday, January 23, 2026

Grant user access to Azure MSDN subscription

For old MSA-originated MSDN / Visual Studio subscriptions, we might not be able to grant user access to the subscription. The subscription is linked to your personal account, and there is a portal-side RBAC picker defect caused this issue. To grant access to the subscription to other users created in your directory, using following Azure CLI (Cloud Shell) and grant the user contributor role. az role assignment create \ --assignee-object-id <USER_OBJECT_ID> \ --assignee-principal-type User \ --role Contributor \ --scope /subscriptions/<SUBSCRIPTION_ID> Subsitute <USER_OBJECT_ID> with the Object ID for the user in Microsoft Entra ID, and <SUBSCRIPTION_ID> for the subscription in question.

Posted by John Liu Friday, January 23, 2026

Fabric Mirrored SQL Server Data Gateway Issue

When create mirrored SQL server in Fabric to on-premises SQL database, we will need to use On-Premises Data Gateway. We might encounter issue with Use Encrypted Connection option with self-signed certificate. To resolve issue with Use Encrypted Connection, try following solutions: Solution 1: Add your SQL Server to the “Trusted Servers” List: There is a “hidden” configuration in the On-premises Data Gateway that allows you to bypass certificate validation for specific servers.

Posted by John Liu Friday, January 9, 2026