If you want to avoid creating multiple refreshes to a data source, it's better to use linked tables to store the data and act as a cache. If you want to reuse a table across multiple dataflows, such as a date table or a static lookup table, you should create a table once and then reference it across the other dataflows. The following list describes some of the reasons you might choose this approach:

Create a dataflow by using linked tablesĬreating a dataflow by using linked tables enables you to reference an existing table, defined in another dataflow, in a read-only fashion. The reconnection keeps the data in your dataflow refreshed at the frequency that you select later in the setup process.Īfter you select the data for use in the table, you can use dataflow editor to shape or transform that data into the format necessary for use in your dataflow. When you choose data and a source, Power BI reconnects to the data source. Once connected, you can select which data to use for your table. When you select a data source, you're prompted to provide the connection settings, including the account to use when connecting to the data source, as shown in the following image. Using the Define new tables option lets you define a new table and connect to a new data source. Create a dataflow by using define new tables Dataflows can be created by users in a Premium workspace, users with a Pro license, and users with a Premium Per User (PPU) license.

Ecancrusher docdataflow