Power BI Connector > Mappings and Mapping Tasks with Power BI Connector > Power BI Target and Advanced Target Properties
  

Power BI Target and Advanced Target Properties

In a mapping, you can configure a target to represent a Power BI target. For a Power BI target connections used in Mapping tasks, you can configure the target and advanced target properties in the Targets page of the Mapping Task wizard.
The following table describes the Power BI target properties that you can configure in a Target transformation:
Property
Description
Connection
Name of the Power BI target connection.
Target Type
Type of the Power BI target objects available.
Object
Name of the Power BI target object.
Operation
Select the target operation.
Note: You must select only the Insert operation.
Create Target
Creates a target.
Enter a name of the target object. Power BI Connector creates a target object in the .csv file format and stores the file in a container in the Microsoft Azure Blob Storage.
You can also select an existing target.
The Package Explorer displays the Azure storage container and a folder that contains all the supported standard objects from common data model. You can select the standard objects from common data model or create custom objects, if you are creating a mapping for the first time. The Azure storage container contains only those objects that are already available and represented in the model.json file.
When you run a mapping to write an object that is not present in the Azure storage container and model.json file, the object is added in the Azure storage container as a data file in the .csv file format and in the model.json file.
When you run a mapping to write an object that is already present in the Azure storage container in the .csv file format and in the model.json file, only the corresponding data file in the .csv file format in the Azure storage container and the corresponding object present in the model.json file are overwritten. The other objects present in the Azure storage container and model.json file are not overwritten.
For example, when you run a mapping to write an Account object for the first time, the Azure storage container will contain the Account object in the account.csv file and model.json file. The next time when you write the Account object, only the existing Account object is overwritten in the account.csv and model.json file.
The following table describes the Power BI target advanced properties that you can configure in a Target transformation:
Property
Description
Power BI Workspace ID
The ID of the workspace that you create to create an external data flow on the Power BI Online.
For more information about creating a Power BI Workspace and obtaining the Power BI Workspace ID, see https://docs.microsoft.com/en-us/power-bi/service-create-distribute-apps.
PowerBI DataFlow Name
Name of the Power BI external data flow name on the Power BI Desktop.
If you do not specify this property, the Secure Agent sets the Power BI data flow name as <Container_Name>_dataflow.
Forward Rejected Rows
Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows.
By default, the mapping task application forwards rejected rows to the next transformation.