Forum Discussion

JeffTrevorJones's avatar
JeffTrevorJones
Frequent Visitor
2 years ago
Solved

Power BI Project files and Composite Models

I've converted our pbix files to Power BI Project (pbip) files in order to leverage source control with Git and Azure DevOps.  Several of my models in the pbix format are composite models.  When doin...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi JeffTrevorJones ,

    Firstly I think you can open the PBIP file that contains the composite model. Then you can go to the Model view and identify the tables that are directly referencing the dataset.

     

    Select the table that is currently in Import mode.

    In the Properties pane, change the Storage Mode to DirectQuery.

     

    You can also go to Power Query and edit the Advanced Editor.

     

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi JeffTrevorJones ,

Firstly I think you can open the PBIP file that contains the composite model. Then you can go to the Model view and identify the tables that are directly referencing the dataset.

 

Select the table that is currently in Import mode.

In the Properties pane, change the Storage Mode to DirectQuery.

 

You can also go to Power Query and edit the Advanced Editor.

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.