Power Bi - How to Add a Table from the Presentation Layer into the .Pbit Model

Introduction

Within the .pbit files that we share we only include tables that are required for the reports, this is to help with the performance of the reports when opening them. The more tables included the slower the performance.

However we are regularly including new data items into the warehouse which you will be notified by the release notes.

If the new fields is included on an existing table in the model then they will automatically be added into the model, if they are associated to a new table then you will need to add the new table to the model.

User Roles

  • Approved Data Warehouse Users

 How to: Add a Table from the Presentation Layer into the .pbit Model

 

Below are the steps on how to do this from within PowerBI:  

Step One :  Select transformation data 

blobid0.png

 

Step Two : Select any table 

blobid1.png

 

Step Three : Select  “advance editor” from the ribbon 

 

blobid2.png

Step Four : Copy the M code in the advanced editor  

 

blobid3.png

 

Step Five: Select “New Source” and “blank query” 

blobid5.png

Step Six: Select “advanced Editor” on the blank query 

blobid7.png

Step Seven  : Paste the Copied M code modifying to include the required table 

blobid6.png

 

Step Eight : Close and Apply 

blobid8.png

 

Step Nine  Manage Relationships , please note it is not recommended to use the auto detect relationships


Select the model:

blobid9.png

Connect the new table to existing tables: drag and drop the connection point 

blobid10.png

Step Ten: Set the cardinality 

 Right click and select properties 

blobid11.png

  blobid12.png

N.B: Make sure that the relationships is marked as active. 

 

Was this article helpful?

1 out of 1 found this helpful

Have more questions? Submit a request