Forum Discussion
Power BI downloaded PBIX does not contain Power Query queries
Hi aliciaortega93,
Thank you, MFelix jgeddestayloramy for your insights,
The PBIX file uses a DirectQuery or composite model architecture rather than the standard Import model, which is why the Power Query view appears empty. According to Microsoft documentation, adding local or import tables to a DirectQuery semantic model creates a composite model, which can result in limited relationships across sources and may lead to unexpected calculation or relationship issues. Adding the PMO_Weekly source probably changed the model’s structure and affected existing relationships or metadata. The best practice is to extend the original semantic model rather than make changes directly in the downloaded PBIX.Use composite models in Power BI Desktop - Power BI | Microsoft Learn
Composite model guidance in Power BI Desktop - Power BI | Microsoft Learn
Download a Report from the Power BI Service to Power BI Desktop - Power BI | Microsoft Learn
Use DirectQuery in Power BI Desktop - Power BI | Microsoft Learn
Thank you.
Thank you so much for your reply! If I go there, I see the following:
Any ideas what should I do next?
You can drag any of the elements from the Expression list, or any of those categories, onto the main screen. The coding will then populate. From there hopfully you can get a bit more insight into the connections in the model.