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.
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,
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,
Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.
Thank you.
Hi aliciaortega93,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.