Forum Discussion
Power BI downloaded PBIX does not contain Power Query queries
- 3 months ago
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 for your reply! When I click on that, I see the following:
The last one, get_pmo_weekly is the new one I'm trying to use in the data.
At the top select the the first radio button to show only data sources in the report.