Wednesday, November 4, 2020

Copying a Data Flow in Microsoft Power BI

Copying a Data Flow in Microsoft Power BI

Dataflows cannot be changed /copied directly. We need to download the .json file and import it in a new data flow.

Step 1

Select the dataflow you want to copy and click on the last icon, It should give you options like below. select the 'Export .json' and it will download the .json file on to your desktop.



Step 2

Go to new data flow and select the 'Import Model' option.


Step 3 

Once the file is selected, you get below pop up saying it is being imported and after successful import, you can see the dataflow in your list.


You are the owner of the newly uploaded dataflow and you can make any changes you want.



Error and Corrections

Error
"Invalid dataflow parameter. Exception details : The AllowNativeQueries attribute of the mashup is set to true for this dataflow definition. For security reason, AllowNativeQueries should be set to false, and try again."









Correction
Change the attribute '"allowNativeQueries":false' to true ( "allowNativeQueries":true) and try importing again. It should go through.
Please make sure that you have access to the underlying database.



Other Links to Refer