PowerApps Common Data Service Connector

No comments

Here is how to get PowerApps Common Data Service Connector working.

Note: You need to have Admin rights to Enable Power BI Integration

  • Login to https://web.powerapps.com
  • On the top right corner click on Settings (gear icon)1_1
  • Select Admin Center
  • Select the environment you want to enable
  • Select Database from the top menu
  • Select Enable

2

Now we have enabled Power BI Integration, let’s connect to it using Power BI Desktop

  • Open Power BI Desktop
  • From the ribbon, select GetData
  • In the GetData dialog, select Online Services from the left panel

3

  • Select PowerApps Common Data Service from the right panel
  • Select Connect
  • Select the Environment from the drop down and click OK
  • Navigator dialog opens. Expand the left panel and select the subject area you want to connect to
  • Click OK

Notice in the Fields section you have the list of tables related to the subject area you selected

4

Once you expand a table notice there are sub folders as well. My guess is behind the scenes this is a tabular model

Have fun exploring!!!

 

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s