Common Data Service (CDS) vs Azure SQL Database

CDS Azure SQL Database The main benefit of the CDS is that it's simple to use. Non-IT guys can use it very easily to design their database On the other hand, Azure SQL needs to be managed by someone who has knowledge of relational database and SQL Queries CDS tables can be designed through web-based … Continue reading Common Data Service (CDS) vs Azure SQL Database

Advertisements

Dynamics 365 v9 with Power BI

Recently my old Power BI reports stopped working when the Dynamics CRM (Dynamics 365) was updated to v9.0 and Power BI was updated in July 2018. Power BI has released some changes in OData endpoint connectivity. The issue can be resolved by changing the connection from Advanced editor from OData.Feed("https://d365_instance.api.crm.dynamics.com/api/data/v8.2") to OData.Feed("https://d365_instance.api.crm.dynamics.com/api/data/v8.2", null, [Implementation="2.0"])  

Solved – How to replace Data Source for existing report?

After development of Report or Dashboard from Development Server, we need to switch to the production data. To achieve this we will need to change the datasource of Power BI PBIX file. Here are the steps to do so In Power BI Desktop,  go to File -> Options and settings -> Data source settings. Select the … Continue reading Solved – How to replace Data Source for existing report?

Purchase Order Posting Dynamics AX 2012

I found this chart to help us remember what setup fields are used in packing slips and invoices when posting purchase orders in AX 2012 under the new accounting framework. I believe some of the posting complexity is due to accommodating Standard Costing in addition to other costing methods. In addition download the whitepaper from … Continue reading Purchase Order Posting Dynamics AX 2012

Update User Information after Restoring AX Database to a new environment

After restoring the Dynamics AX Database from one environment to another environment, where the domain name is different, you will not be able to log on to AX unless you have updated the SID and user information through SQL Query. Run the below mentioned query on the restored database. update userinfo set networkdomain = 'NEW-DOMAIN-NAME', networkalias … Continue reading Update User Information after Restoring AX Database to a new environment