User Profile
Kidd_Ip
MVP
Joined 5 years ago
User Widgets
Recent Discussions
Re: Logic App Workflow() function returning un-expected results
The difference you are seeing comes from the two hosting models of Logic Apps. In Consumption (multi-tenant) Logic Apps, the workflow() function returns a fully qualified resource ID with subscription, resource group, and provider details. In Standard Logic Apps, the workflow() function returns a shorter, relative path (/workflows/<workflowId>). That’s why your error handler logic works in one case but not the other. To fix this, you are required to normalize the run identifiers or construct the portal URL differently depending on the hosting model.2Views0likes0CommentsRe: Filter on array length in Azure Cognitive Search
Azure Cognitive Search does not support filtering directly on array length (e.g., Contracts/count eq 0). The OData filter syntax only allows any and all for collections. To find records where an array is empty, you must use a workaround such as checking for null or using not Contracts/any().3Views0likes0CommentsRe: App Service for Windows in Germany North
Yes, until now App Service for Windows is not available in the Germany North region, and Microsoft has not announced any official plans or timelines to make it available there. If you need App Service for Windows in Germany, the supported option is Germany West Central, which currently offers full App Service capabilities. Product Availability by Region4Views0likes0CommentsRe: Looking for a solution - My API clients will be impacted due to Azure TLS 1.0, 1.1 retirement
After 31-Oct-2024, Azure will no longer accept TLS 1.0 or 1.1 connections. If your devices cannot be upgraded to support TLS 1.2, they will not be able to connect directly to Azure App Services or API endpoints. The only way forward is to introduce a compatibility layer or proxy that can accept TLS 1.0/1.1 from your devices and then forward traffic to Azure using TLS 1.2+.15Views0likes0CommentsRe: Sentinel and limitation of 100 Sentinel instances per page as MSSP
As of now, Microsoft Sentinel multi tenant management portal does enforce a limit of 100 instances per page/view, and there is no publicly announced plan to raise that cap. Microsoft acknowledges this as a constraint for MSSPs, but the official guidance is to use workarounds such as API queries, automation, or third party MSSP management tools to handle more than 100 tenants: Microsoft Sentinel service limits | Microsoft Learn9Views0likes0CommentsRe: Fetching JSON object from Cosmos DB in Azure Synapse Studio fails
Would suspect that the reason your failing_complex_object always returns NULL is that Synapse OPENROWSET with Cosmos DB doesn’t automatically flatten nested JSON objects into string columns. Arrays and simple objects serialize fine, but nested objects with multiple child properties (like your data_01 and data_02) often fail unless you explicitly cast them as NVARCHAR(MAX) and then use JSON_QUERY without a path. In other words, the column definition in your WITH clause is discarding the nested object because Synapse expects a scalar value, not a structured JSON object.2Views0likes0CommentsRe: Migrating from Outlook.com to Microsoft 365 Business Basic
You may not directly import Outlook.com mailboxes into Microsoft 365 Business Basic using PST or IMAP, but you can migrate them by connecting Outlook.com accounts to Outlook desktop and then moving mail into the new Microsoft 365 mailboxes, or by using Microsoft’s migration tools (Mail Migration Advisor, Exchange Online import service, or third‑party migration utilities).8Views0likes0CommentsRe: Windows 11: WiFi disconnected every time computer wakes jup
See whether below steps can help: Forget and re‑add the Wi‑Fi network Settings → Network & Internet → Wi‑Fi → Manage known networks. Select your network → Forget. Reconnect and re‑enter the password, making sure “Connect automatically” is checked. Check adapter power settings Device Manager → Network adapters → [Your Wi‑Fi adapter] → Properties → Power Management tab. Uncheck “Allow the computer to turn off this device to save power.” This prevents Windows from disabling Wi‑Fi during sleep. Update or reinstall Wi‑Fi drivers Right‑click adapter → Update driver. Or download the latest driver directly from the laptop/adapter manufacturer’s site. Outdated drivers are a frequent cause of wake‑up disconnects. Disable Fast Startup Control Panel → Power Options → Choose what the power buttons do → Change settings that are currently unavailable. Uncheck “Turn on fast startup.” This can stabilize wake‑up behavior.8Views0likes0CommentsRe: CANNOT OPEN THE SPECIFIED FILE with tel:-hyperlink
You may check on below: 1. Check Windows default apps o Go to Settings → Apps → Default apps → Choose default apps by protocol. o Scroll down to TEL and see which app is assigned. If it’s blank, assign WhatsApp (or another calling app). 2. Test outside Excel o Open a browser and type tel:+123456789. o If nothing happens, Windows doesn’t know what to do with tel: 3. Excel Trust Center o File → Options → Trust Center → Trust Center Settings → External Content. o Make sure hyperlinks aren’t being blocked. 4. Recreate the hyperlink o Right-click → Edit Hyperlink → re-enter tel:+number.7Views0likes0CommentsRe: Excel interprets dates 12 and lowers as months
You aware Excel does not actually “know” whether you mean dd/mm or mm/dd when you type something like 4/8. By default, Excel interprets ambiguous dates based on your system’s regional settings (Windows short date format). That’s why 15/8 works (since 15 can’t be a month, Excel has no choice but to treat it as a day), but 4/8 flips to April 8 because both 4 and 8 could be valid months.11Views0likes0CommentsRe: Power Query - Large Data Set Question
You may hit one of the classic pain points with Excel which is 1,048,576 row limit. With 5 million rows and about 180k project IDs, you are already pushing Excel beyond what it was designed for. Power Query can crunch that much data, but once you load it back into the Excel grid, you hit the ceiling. You may consider this as workaround: Since you specifically want the project IDs with exactly 1 duplicate (count = 2): Do the grouping in Power Query. Filter for Count = 2. Load the results into the Data Model (not the sheet). Use a PivotTable to explore or export to CSV if you need the raw list. This way, you bypass the worksheet limit entirely while still working inside Excel.9Views0likes0CommentsRe: Restore Authentication App do not work
Microsoft Authenticator recovery only works if you had Cloud Backup enabled before deleting the app. If backup was not set up, recovery won’t work. The error you are seeing when trying to enable backup usually comes from account sync issues, time/date mismatches, or Android restrictions. The fix is to check your Microsoft Account security settings, ensure the app has proper permissions, and re-add accounts manually if backup was not active.23Views0likes0CommentsRe: Same Number
It maybe the problem when the column is part of an Excel Table or has a formula applied across the column. When you type a number, Excel automatically replicates it to all rows in that structured column. To fix it, convert the table back to a normal range or clear the formula so each cell can hold its own independent value.16Views0likes0CommentsRe: Can't setup MFA on Azure personal account
You can’t enable MFA for a personal Microsoft account (e.g. @outlook.com, hotmail.com) in the same way you do for an Azure AD “work or school” account. The https://aka.ms/MFASetup portal only works for organizational tenants. For personal accounts, MFA is managed through Microsoft Account security settings, not Azure AD. To use az cli with MFA enforced on your free trial tenant, you’ll need to either: Create an Azure AD tenant with a work/school account (recommended), or Switch to device code authentication in az cli, which bypasses the MFA setup portal and works with personal accounts.6Views0likes0CommentsRe: AVD session host with Hybrid join
Seems related to Azure Virtual Desktop agent registration, hybrid join timing, or ADDS authentication alignment area. Multi-session hosts are more sensitive to broker/agent connectivity and profile container mounting delays. Check agent health, hybrid join status, and RDP properties like targetisaadjoined:i:1 to ensure proper login flow.22Views0likes1CommentRe: ADF Copy activity runs for too long
Your ADF copy activity is timing out because of slow write throughput to Azure SQL combined with self-hosted IR bottlenecks. Common causes include network latency from on-prem to Azure, insufficient batch size or parallelism, Azure SQL throttling, or interim staging table overhead. You can improve performance by tuning batch size, parallel copy settings, staging options, and IR resources, and by monitoring Azure SQL DTU/CPU usage.5Views0likes0CommentsRe: Azure Pipeline Template times out when trying to create a table that already exists.
The pipeline fails because the template default script always tries to create the target table, even if it already exists. To fix this, you need to adjust the pre-copy script or pipeline logic to use IF NOT EXISTS (or DROP TABLE IF EXISTS before creation), or disable the “Create table” step if the schema is already provisioned.5Views0likes0CommentsRe: F&O Dataverse Limitation?
To my understanding, the answer is NO, customers do not need to purchase additional Dataverse database capacity but just to use Azure Synapse Link with Finance & Operations (F&O). Synapse Link streams data directly from Dataverse into Azure Synapse Analytics or Azure Data Lake Storage Gen2, and the storage/compute costs are incurred in Azure but not in Dataverse. However, Dataverse capacity limits still apply for transactional storage, so if your F&O integration generates unusually large volumes of data, you may need to monitor and possibly expand Dataverse capacity for the operational side.4Views0likes0CommentsRe: Cannot access my account after code from Authenticator App does not work after I change my mobile
If you have changed phones and lost access to Microsoft Authenticator, you’ll need to use Microsoft account recovery process. You cannot disable Authenticator yourself without logging in, but you can escalate to Microsoft Account Recovery or tenant recovery (for business accounts). This requires proving ownership with billing details, subscription IDs, or domain verification. Once verified, Microsoft support can reset your MFA settings.15Views1like1Comment
Recent Blog Articles
No content to show