QuickFix: Set default browser in Visual studio for debugging

If you are also facing issue when debugging VS opens objects in IE, ironically Microsoft says its not supported any more but still object opens in IE.

So to change the default browser to Chrome or any other, navigate to Visual Studio Extension > Dynamics 365 > Option > Debugging 

set the default browser here as per your choice 

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

Best way to do Postman setup with D365FO

Hi Folks, 

There are very simple steps to do initial setup between Postman and D365FO environment. Please follow below steps.

(Make sure you have added a record in 'Azure Active Directory applications' in D365FO under Sys admin > setup > Azure Active Directory applications )

1. Download postman from here and install on you machine.

2. Do app registration on Azure portal, and make sure you copy all details from app registration to a safe place as not all information will available for later use.

3. Go to environment in left pane and create a new environment, you can name it as same as your D365FO environment like DEV01, UAT, Test etc. This also help when you are working with multiple environment and you keep using same get/post script to access different environments. 

4. Add all the variables here as below

Client_ID: You will get it from Azure app registration. 

grant_Type: client_credentials

resource: D365FO environment URL i<https://D365FOUrl/>

client_secret: You will get it from Azure app registration. 

tenant_id: You will get it from Azure app registration. 

access_token: To generate access token follow step 9.

5. Now create new collection and name it with your environment name eg. Dev01

6. Next, click on 3 dots next to collection name and select 'add request'

7. Name this request as 'Authorization', you can name it as per your use like getting public entities details or get a specific entity data or metadata. In the post request paste below as is.

https://login.microsoftonline.com/{{tenant_id}}/oauth2/token

8. Select 'From-data' in body and set below details.

Now you see we parameterize most of things and you don't need to create multiple request for different environments, you can simple change the environment from right top corner. 

9. Now,  Click on send button and you should get a status 200 message with access token. 

You can add the access token to your environment variable. 

Here we have completed the Postman setup. Now you can try few things to explore this further

10. Add one more request in your collection, and add details as below to get list of public entities. 

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

QuickFix: [Solved] SSRS Report Deployment failed - The number of defined parameter is not equal to the number of cell definitions in the parameter panel

While duplicating an SSRS report for customization sometimes you may face this error at the time of report deployment. 

Error Message:

"SSRS Report Deployment failed - The number of the defined parameters is not equal to the number of cell definitions in the parameter panel."

Solution: 

The first thing you need to check for any extra parameter is this report, compare with the standard report. There are two places you need to compare

1. DataSet parameters

2. Report Parameter

There might be an extra parameter(s), try to remove this extra parameter from the report. In case you are unable to delete it from the front end you need to open the report in XML (Right-click on the report in solution and select open with > Open with XML Text editor).

In the XML file search for this parameter and carefully remove it from everywhere. If you are not familiar with XML better to take help. Save your changes and build the solution. This time your report should be deployed without any error. 

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta

[Solved] Issue with Database import in Dev Box

Hi Folks, 

While trying to import the UAT database into dev box or any other tier -1 box (You might have try this MS document), 

*** Changes to connection setting default values were incorporated in a recent release.  More information is available at https://aka.ms/dacfx-connection

*** Error importing database:Could not import package.

Changes to connection setting default values were incorporated in a recent release.  More information is available at https://aka.ms/dacfx-connection

Unable to connect to target server 'localhost'. Please verify the connection information such as the server name, login credentials, and firewall rules for the target server.

A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)

The certificate chain was issued by an authority that is not trusted.

*** The settings for connection encryption or server certificate trust may lead to connection failure if the server is not properly configured.

That's because of recent changes with encryption policies on SQL. To fix this issue you need to update the import SQL command as below

SqlPackage.exe /a:import /sf:J:\MSSQL_BACKUP\UATbackup.bacpac /tsn:localhost /tdn:AXDB_UAT /p:CommandTimeout=1200 /TargetEncryptConnection:False

-Harry Follow us on Facebook to keep in rhythm with us. https:fb.com/theaxapta