Category: Miscellaneous

The refresh token has expired due to inactivity when connecting to Power Pages using Power Apps CLI – Quick Fix

Hi Folks,

This post is about a quick fix for an error occurred with Power Apps CLI.

I was trying to connect to my organization using CLI and that’s when I encountered this error.

Prerequisites:

Power Apps CLI, Visual Studio Code

After installing the prerequisites, I was trying to connect to my Power Pages available in my organization from VS Code terminal using below command.

pac paportalist

It’s then I encountered the below error

It’s then I understood that due to inactivity, it is failing…

Your Power Platform CLI connection is failing due to an expired refresh token and an ExternalTokenManagement Authentication configuration issue. Here’s how you can resolve it:

Fix:

Reauthenticate with Dataverse

pac auth clear
pac auth create --url https://orgXXX.crm8.dynamics.com --username admin@Ecellors.onmicrosoft.com --password [your password]

Creating new authentication profile resolves this issue…

    Now try to run the above command.

    This should prompt a new login window to authenticate your request, provide the details and you should be able to login.

    Hope this helps..

    Cheers,

    PMDY

    Connecting to your Dataverse instance to run SQL Queries without using XrmToolBox

    Hi Folks,

    Do you know that you can connect to your Dataverse DB right from your old toolbox SSMS, an express version would be more than enough to try out. Possibly we didn’t think of, but yes, we can…so let’s see that in this blog post.

    Open SSMS..

    1.Select Server type as Database Engine

    2. Server name as the environment URL from your Power Platform Admin Center as below.

    3. So key in those details as below, make sure to Select Authentication method as Azure Active Directory – Universal with MFA option.

    Once you click on Connect, you will be prompted for authentication via browser.

    Once your Sign-In is successful, you will be able to see.

    That’s it, how simple it was connecting to your Dataverse instances…

    Having said that it’s easy to connect to Dataverse, not all operations performed using normal transact SQL are supported here using Dataverse SQL. You could see it says Read-Only besides the instance name, that means that you don’t have any capabilities to modify from SQL.

    Because Dataverse SQL is a subset of Transact-SQL. If you want to see what statements are supported and what not, just go ahead to this link to find out.

    This opens a whole lot of opportunities to explore, so don’t forget to check this out.

    References:

    Dataverse SQL and Transact SQL

    Cheers,

    PMDY