Meta tags:
description=Microsoft Dynamics 365 Business Management Solution Enthusiast;

Headings (most frequently used words):

to, with, in, claude, write, dynamics, 365, price, and, powerbi, user, mcp, for, desktop, unified, management, failed, dual, error, cloud, symptoms, solution, step, config, application, erpcoder, development, code, back, data, functions, contact, center, dataverse, sql, configure, best, discounts, d365, scm, how, use, your, custom, product, attributes, vscode, al, download, symbols, authorization, has, authenticate, unable, get, access, token, from, tier1, hosted, sales, installation, missing, dependencies, runas, history, by, app, registration, self, signed, certificate, via, powershell, add, root, authorities, web, wif, power, platform, entraid, fo, tag,

Text of the page (most frequently used words):
the (117), and (56), #dynamics (49), 365 (45), write (30), with (30), dual (25), from (21), carrier (21), can (16), powerbi (15), sales (15), solution (15), for (15), data (15), #claude (15), finance (14), user (14), application (13), price (13), you (12), under (11), environment (11), customer (11), comment (10), tagged (10), filed (10), database (10), code (10), installation (9), error (9), leave (9), was (9), use (9), supply (8), chain (8), that (8), 2025 (8), also (8), how (8), power (8), new (8), selected (8), business (8), table (8), management (8), copilot (8), this (7), operations (7), admin (7), has (7), platform (7), dataverse (7), fabric (7), tables (6), but (6), create (6), like (6), add (6), value (6), certificate (6), file (6), tier1 (6), microsoft (6), failed (6), sql (6), function (6), required (5), report (5), erpcoder (5), have (5), com (5), account (5), package (5), details (5), following (5), are (5), packages (5), app (5), source (5), page (5), core (5), lcs (5), center (5), authentication (5), work (5), mcp (5), connection (5), cursor (5), part (5), development (4), cloud (4), azure (4), machine (4), here (4), type (4), into (4), configure (4), entraid (4), synchronization (4), etc (4), found (4), record (4), added (4), web (4), spn (4), config (4), your (4), cert (4), desktop (4), url (4), d365 (4), enabled (4), workspace (4), configuration (4), based (4), windows (4), central (4), domain (4), video (4), unified (4), back (4), analysis (4), generate (4), selectedvalue (4), priceperqty (4), var (4), comments (3), wordpress (3), other (3), blog (3), methodology (3), posts (3), common (3), additional (3), not (3), import (3), some (3), dependencies (3), missing (3), full (3), initial (3), will (3), solutions (3), well (3), been (3), using (3), finally (3), created (3), system (3), key (3), thumbprint (3), registration (3), cer (3), root (3), authorities (3), documentation (3), simple (3), including (3), che (3), information (3), unable (3), entity (3), accounts (3), get (3), access (3), records (3), product (3), legal (3), two (3), deployed (3), linked (3), visual (3), vscode (3), runas (3), password (3), symbols (3), works (3), authorization (3), short (3), discounts (3), tasks (3), coding (3), model (3), let (3), 2026 (3), return (3), carrierselection (3), sqldb (3), udf (3), functions (3), active (3), calculate (3), selectedprice (3), selectedcarrier (3), log (2), sign (2), subscriptions (2), office (2), covid (2), aif (2), learning (2), global (2), address (2), book (2), human (2), resource (2), order (2), there (2), see (2), imported (2), missingdependencies (2), missingdependency (2), schemaname (2), cdm_worker (2), displayname (2), worker (2), msdyn_transferorder_receivingcontactpersonnel (2), when (2), installed (2), install (2), since (2), its (2), setup (2), within (2), april (2), customers (2), any (2), groups (2), users (2), role (2), already (2), existing (2), service (2), updated (2), 0000 (2), wif (2), made (2), export (2), clicking (2), done (2), choosen (2), certname (2), self (2), signed (2), via (2), powershell (2), api (2), read (2), all (2), connections (2), environments (2), step (2), https (2), token (2), authenticate (2), synchronized (2), matter (2), successfully (2), basic (2), mappings (2), were (2), only (2), one (2), sandbox (2), deployment (2), studio (2), test (2), symptoms (2), hosted (2), provide (2), download (2), reports (2), joined (2), prem (2), server (2), june (2), recorded (2), shows (2), attributes (2), best (2), visualization (2), context (2), protocol (2), connects (2), without (2), find (2), chat (2), natural (2), language (2), background (2), german (2), query (2), allows (2), connect (2), way (2), magic (2), demonstrate (2), handle (2), phone (2), calls (2), summarize (2), cases (2), articles (2), used (2), values (2), aka (2), contact (2), great (2), supports (2), different (2), close (2), execute (2), insert_description_query (2), saleslt (2), delete_carrier (2), str (2), parameter (2), button (2), actual (2), isblank (2), defaultprice (2), status (2), defaultcarrier (2), measures (2), demo (2), contains (2), carrierselected (2), year (2), date (2), dimension (2), project (2), about (2), enthusiast (2), website, name, email, loading, collapse, bar, content, manage, view, site, reader, privacy, now, join, subscribers, subscribed, subscribe, upgrade, uncategorized, mobile, enterprise, portal, net, tag, older, worked, apr, labeled, troubleshoot, fix, problem, retry, directions, msdyn_dynamics365supplychainextendedanchor, notprovided, manifest, failure, cannot, dynamics365supplychainextended, canresolvemissingdependency, true, hcmcommon, dependent, parentschemaname, parentdisplayname, productupdatesonly, false, might, run, deploying, trigger, end, experience, original, orchestration, replaced, pack, smaller, needed, correct, deploy, template, working, products, orders, invoices, avoid, problems, applications, settings, assigned, administrator, xml, version, identitymodel, identityconfiguration, securitytokenhandlers, securitytokenhandlerconfiguration, audienceuris, warning, must, first, element, instance, startup, 00000015, c000, 000000000000, my_app_id_here, aad, realm, infrastructure, s2scertthumbprint, graphapi, graphapiserviceprincipalcert, aosservice, webroot, directory, copy, before, editing, changed, lines, tab, generates, double, computer, twice, local, place, same, placed, cername, myselfcert, selfsignedcertificate, subject, certstorelocation, currentuser, keyexportpolicy, exportable, keyspec, signature, keylength, 2048, keyalgorithm, rsa, hashalgorithm, sha256, filepath, admin051a5b362b, certification, gave, permissions, erp, fullaccess, user_impersonation, response, oauth, cut, off, accessing, tenant, folks, dealing, events, instructions, etup, onebox, __crm4, troubleshooting, fwlink, linkid, 2244045, vice, versa, did, soon, message, came, possible, link, corresponding, assign, group, seconds, became, entities, currencies, units, size, colors, successful, between, customersv3, populated, synchronize, company, apps, because, prototype, next, after, configurations, performed, restored, axdb, dev, dialog, integration, took, while, succeeded, history, deprecated, still, good, reasons, them, anyway, instead, udes, withing, lifecycle, services, paired, encountered, creating, may, ad_domain, ad_user, path_to_vscode, exe, workaround, solved, issue, command, open, browser, asks, correctly, entra, logged, non, client, workgroup, credentials, expired, credential, cache, cleaned, reach, would, require, colleague, developing, ran, downloading, although, provided, his, july, custom, second, explaining, concurrent, school, black, friday, august, scm, connecting, adeventure, performs, llms, chatgtp, gemini, very, convenient, lot, generating, optimizing, documents, perform, intelligence, need, classic, tool, november, investigate, structure, dont, related, out, own, talk, english, oder, connected, example, impementation, manipulate, sounds, december, concact, capabilities, chats, propose, kbx, knowledge, base, adds, callcenter, agent, compentency, technic, priority, silver, gold, serivce, addon, purpose, direct, interaction, channels, sms, routing, february, commit, insert, delete, def, write_one_to_sql_db, fabricsqlconnection, argname, alias, adventureworksl, userdatafunctions, uuid, artifact, uses, sources, case, string, input, deletes, entry, inserts, happens, blank, action, takes, measure, passes, shipping, costs, multiplying, salesorderdetails, qty, selecting, immediately, updates, creates, flags, nothing, seleced, flagged, otherwise, clicked, post, dpd, dhl, ups, holds, adventure, dataset, hols, delivery, providers, delivered, implemented, small, what, simulations, lacks, ability, save, results, structured, combination, implement, lakehouse, dax, requiremet, prompt, totals, comparison, telling, which, formulars, reusable, skill, another, modify, planning, mode, files, combining, help, speed, mini, series, usage, vibe, delegate, boring, modeling, more, home, search,

Text of the page (random words):
ode in vscode create the initial claude md file and let claude generate a source database documentation part 2 use claude code to modify the data model generate a date dimension table and use the planning mode part 3 create a reusable skill for a date dimension table and test it in another report part 4 generate dax measures from requiremet prompt to summarize the totals and year by year comparison without telling claude code which formulars to use filed under bi powerbi tagged with claude powerbi powerbi write back with user data functions 8 april 2026 leave a comment powerbi is great for data analysis and visualization it also supports what if simulations but lacks the ability to save analysis results in a structured way in combination with fabric user data functions you can implement a simple write back to a data source in fabric e g database lakehouse i ve implemented a small demo application in fabric the workspace contains a sql database a user data function and a powerbi report the database holds an adventure works demo dataset it contains two additional tables carrier and carrierselected the carrier tables hols package delivery providers and the price for a package to be delivered the carrierselected has only 1 record with the selected carrier carrier priceperqty ups 12 dhl 13 dpd 7 post 11 powerbi creates a table that flags the selected carrier i m using two measures to get the actual selected carrier and price if nothing is seleced the price is from the record flagged as selected otherwise the selected aka clicked record in the table visual active carrier var selectedcarrier selectedvalue carrier carrier var defaultcarrier calculate selectedvalue carrier carrier carrier status selected return if isblank selectedcarrier defaultcarrier selectedcarrier active priceperqty var selectedprice selectedvalue carrier priceperqty var defaultprice calculate selectedvalue carrier priceperqty carrier status selected return if isblank selectedprice defaultprice selectedprice the actual price is used to calculate the shipping costs by multiplying the salesorderdetails qty with the package price selecting a different carrier immediately updates the price the magic happens when clicking on the write back to sql button this is a blank button with the action enabled and a linked data function it takes the value from the active carrier measure and passes it as parameter to the data function the user data function is an artifact in the fabric workspace it can uses connections to data sources in fabric in my case it connects to the sql database the function has a string input parameter carrier the code deletes the existing entry in the carrierselection table and inserts the new one import fabric functions as fn import uuid udf fn userdatafunctions udf connection argname sqldb alias adventureworksl udf function def write_one_to_sql_db sqldb fn fabricsqlconnection carrier str str connection sqldb connect cursor connection cursor delete_carrier delete from saleslt carrierselection cursor execute delete_carrier insert_description_query insert into saleslt carrierselection values cursor execute insert_description_query carrier connection commit cursor close connection close return the carrier was updated filed under bi powerbi tagged with fabric powerbi dynamics 365 contact center 10 february 2026 leave a comment copilot serivce workspace aka contact center is great addon for dynamics 365 customer service it s purpose is to handle direct customer interaction it supports different channels like chat sms and phone calls you can configure customer routing e g priority based silver gold callcenter agent compentency e g sales technic copilot adds values to the solution copilot can be used to generate knowledge base articles based on cases copilot can summarize cases and propose solutions based on kbx articles copilot can handle customer chats as well as customer phone calls i ve created a short video to demonstrate dynamics 365 concact center capabilities filed under dynamics 365 ce tagged with copilot dynamics 365 mcp for dataverse with claude desktop 9 december 2025 leave a comment the power of mcp model context protocol allows you to connect an ai application like copilot oder claude to an application in a way that the ai application can work with the connected system in the background for example the mcp impementation for microsoft dataverse allows an ai application to query and manipulate records in the dataverse sounds simple but here is the magic query dataverse in natural language e g find me all german customers chat in your natural language no matter how dataverse was setup in the background e g talk in english and let ai work an a german dataverse installation let the ai investigate the database structure if you dont provide information how tables are related it will find out by its own filed under ai and machine learning tagged with ai claude dataverse power platform mcp for sql with claude desktop 4 november 2025 leave a comment llms like chatgtp copilot gemini claude etc are very convenient for lot of tasks like coding generating and optimizing documents and data analysis with an mcp model context protocol server that connects to a sql database you can use your ai to perform business intelligence tasks without the need of a classic bi tool like powerbi i ve made a short video that shows claude desktop connecting to an azure sql database adeventure works and performs data analysis and visualization filed under bi methodology tagged with ai powerbi configure best price discounts in d365 f scm unified price management 28 august 2025 leave a comment here is my second video on unified price management explaining how to best price discounts work and how to configure concurrent back to school and black friday discounts filed under dynamics 365 finance and operations tagged with dynamics 365 fo price management how to use your custom product attributes in unified price management 3 july 2025 leave a comment i ve recorded a short video that shows how to you use product attributes in unified price management filed under dynamics 365 finance and operations tagged with dynamics 365 fo vscode al download symbols authorization has failed 3 june 2025 leave a comment a colleague developing for on prem business central using vs code ran into an authentication error downloading symbols although he provided his domain user and password the authentication failed authorization has failed or the credentials have expired the credential cache has been cleaned any access to reach business central would require new authorization symptoms business central on prem installation on domain joined server authentication windows visual studio code installed on a non domain joined windows 11 client workgroup work account azure ad entra id user logged on on in windows 11 open url in browser asks for user password but works correctly al download symbols reports an error solution runas a workaround that solved the issue was to use the runas command and provide the domain user password runas user ad_domain ad_user c path_to_vscode exe filed under admin tagged with business central vscode windows dual write error failed to authenticate and unable to get access token from tier1 cloud hosted to dynamics 365 sales 6 may 2025 8 comments since tier1 cloud hosted environments che will be deprecated there are still good reasons to use them anyway instead of udes tier1 che from withing lifecycle services can be paired with power platform environment including dual write configuration with dynamics 365 sales in the tier1 configuration i ve encountered an authentication error at creating new records in fo history and symptoms i ve deployed a new tier1 dev test environment 10 0 43 to the linked azure subscriptions at the configuration dialog in lcs i ve enabled power platform integration based on dynamics 365 sandbox deployment took a while but succeeded after the deployment i ve restored a axdb database with some basic configurations and performed a full database synchronization in visual studio next i ve linked the d365 finance and supply chain machine with the deployed d365 sales sandbox environment from the lcs environment details page finally i ve enabled the dual write configuration also from the lcs environment details page in power platform admin center environment dynamics 365 apps two solutions were already deployed dynamics 365 dual write core and dynamics 365 dual write application core because the environment was a sales prototype i ve added the dynamics 365 dual write human resource dynamics 365 dual write finance dynamics 365 hr common tables dynamics 365 dual write global address book and dynamics 365 dual write supply chain solution from the app source in dynamics 365 finance supply chain at the data management workspace i ve imported the core solution and supply chain solution the table mappings have been populated successfully and i ve choosen to synchronize only one legal entity company with sales the basic table mappings e g legal entities customer groups currencies units size colors etc including initial synchronization from fo to sales were successful i ve also enabled synchronization between customersv3 and accounts in dynamics 365 sales it was possible to create a new account from type customer link it to the corresponding legal entity and assign a customer group the customer account from dynamics 365 sales was successfully synchronized into fo within seconds and became a customer vice versa from dynamics 365 finance supply chain to dynamics 365 sales did not work as soon as a new records in a synchronized table was create a dual write error message came up no matter if it was a customer product etc unable to write data to entity accounts authentication failed with error failed to authenticate for https __crm4 dynamics com api data v9 0 accounts for information on troubleshooting see https go microsoft com fwlink linkid 2244045 unable to get access token solution step by step microsoft has cut off che connections from accessing tenant information i found some blog posts from other folks dealing with business events and a microsoft documentation to s etup onebox environments following the instructions i ve done the following app registration i ve created an app registration in entraid i ve added the url of the d365 fo environment as response url from type web as well as the url including oauth i gave api permissions to user read user read all dynamics erp ax fullaccess and lcs user_impersonation self signed certificate via powershell following the documentation i ve create a simple self signed certification via powershell on the tier1 vm cername myselfcert cert new selfsignedcertificate subject cn certname certstorelocation cert currentuser my keyexportpolicy exportable keyspec signature keylength 2048 keyalgorithm rsa hashalgorithm sha256 export certificate cert cert filepath c users admin051a5b362b desktop certname cer add to root authorities the export generates a cer file by double clicking the file you can install the file on the computer i ve done this twice as local machine and choosen the place to be the root certificate authorities the same with installation as user and also selected the installation to be placed in the root certificate authorities web config and wif config the web config file can be found at k aosservice webroot directory i ve made a copy before editing and changed the following lines the spn is the application id from the app registration the thumbprint can be found in the cer file on the details tab add key aad realm value spn your application id add key infrastructure s2scertthumbprint value certificate thumbprint add key graphapi graphapiserviceprincipalcert value certificate thumbprint in the wif config i ve also added the application id xml version 1 0 system identitymodel identityconfiguration securitytokenhandlers securitytokenhandlerconfiguration audienceuris warning must be first element updated at web role instance startup add value spn 00000015 0000 0000 c000 000000000000 add value spn my_app_id_here application user in dynamics 365 power platform in the power platform admin center on the environment page under settings in groups users i ve added an application user i ve assigned system administrator role like the already existing finance and operations service account entraid application in fo finally to avoid any additional problems i ve also create a new record in dynamics 365 finance supply chain at the entraid applications page finally the synchronization from dynamics 365 finance supply chain to dynamics 365 sales was working customers products sales orders invoices etc can be created in fo and be found sales filed under admin dynamics 365 ce dynamics 365 finance and operations tagged with dual write dynamics 365 fo dynamics 365 sales entraid dual write installation error missing dependencies 11 april 2025 leave a comment since the original dual write orchestration packages has been replaced by a pack of smaller packages its needed to setup the packages in the correct order you can deploy a power platform environment using the dynamics 365 template from within lcs also from the environment full details page you can trigger the installation of dual write solution and initial configure the dual write solution you will end up with dual write core and dual write application core solutions installed to have the full dual write experience you have to install the other packages as well you might run into an installation error when deploying dual write packages from app source error details how to troubleshoot to fix this problem retry installation for directions on how to do this see here msdyn_dynamics365supplychainextendedanchor notprovided solution manifest import failure the following solution cannot be imported dynamics365supplychainextended some dependencies are missing the missing dependencies are missingdependencies missingdependency canresolvemissingdependency true required type 1 schemaname cdm_worker displayname worker solution hcmcommon 2 2 0 3 dependent type 10 schemaname msdyn_transferorder_receivingcontactpersonnel displayname msdyn_transferorder_receivingcontactpersonnel parentschemaname cdm_worker parentdisplayname worker missingdependency missingdependencies productupdatesonly false there is also an additional required package that is not labeled dual write but required the dynamics 365 hr common tables package here is an order of installation that worked for me apr 2025 dual write human resource solution dual write finance solution dynamics 365 hr common tables dual write global address book dual write supply chain filed under admin dynamics 365 ce dynamics 365 finance and operations tagged with dual write dynamics 365 fo dynamics 365 sales older posts tag cloud net admin ai and machine learning aif azure bi cloud covid 19 development dynamics 365 ce dynamics 365 finance and operations dyna...