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.
When I add the new conecction (PMO_Weekly table) it shows errors:
And I reallized that all the relationships of the model are gone:
Hi aliciaortega93,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.