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.
Hi aliciaortega93,
If you open the report in desktop, then click the dropdown right beneath the transform data button in the ribbon, and click data source settings, what do you see in there?
As MFelix mentioned, nothing being in power query implies that the model is using direct query connections and not import mode.
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.