Power BI downloaded PBIX does not contain Power Query queries

Hi everyone,

I am having a very confusing issue with a Power BI report and I would appreciate some guidance.

Background

I inherited a Power BI report created by another developer.
The report is published in Power BI Service and uses several Azure Functions as data sources (REST APIs returning JSON).

Current sources include endpoints like:

• /api/get_jira_epics
• /api/get_jira_tasks
• /api/get_jira_sprints

The report itself works correctly in Power BI Service.

Problem 1 – Downloaded PBIX has no queries

When I download the report from Power BI Service as:

“A copy of your report and data (.pbix)”

and open it in Power BI Desktop:

• the report visuals appear correctly
• the dataset exists
• BUT when I go to:

Transform Data

No queries are visible at all.

So I cannot see or edit the original queries created by the previous developer.

This makes me think the report may be:

• connected to a semantic model
• or partially live-connected

but I am not fully sure.

Problem 2 – Adding a new Azure Function breaks the report

I created a new Azure Function endpoint:

/api/get_pmo_weekly

When I add it in Power BI Desktop using:

Get Data → Web

However, after:

Close & Apply

All visuals start showing errors such as:

There was a problem with one or more fields

The column 'CW_Tasks_Expanded[Week Start]' either doesn't exist

Error fetching data for this visual

• existing tables disappear
• relationships break
• measures become invalid
• old visuals lose references

even though I only added one new Web source.

Additional context

The report uses:

• Azure Functions (REST APIs)
• MySQL Azure database
• multiple DAX measures
• custom visuals
• slicers based on week ranges

My goal was simply:

1. add a new table (PMO_Weekly)
2. keep all existing tables intact
3. create new visuals/measures using the new weekly data

But adding the new source seems to destabilize the whole model.

Questions

1. Why are the original Power Query queries not visible in the downloaded PBIX?
2. Is this behavior expected for reports connected to semantic models/thin reports?
3. Why would adding a single new Web source cause existing tables/measures/visuals to disappear or fail?
4. What is the correct approach to extend this kind of report architecture?

Any help would be greatly appreciated.