Downloaded PBIX Throwing Errors

[FlowHawk]

To fix an error with a measure to a published report, I've downloaded the PBIX from the workspace. Upon opening the PBIX, I get this error:

"Something went wrong
Unable to get the formula text for..." and reference to a table.

Upon clicking cancel, it tells me there are pending changes with every query in my model.

That's as much as I have to go off of. Any idea what could be wrong?

[cashcrane]

Did you ever end up resolving this problem? I have run into the same problem from a downloaded model from the workspace. I checked the troublesome query in SSMS and it never finishes executing and is a query that has been known to have an issue. Tried to delete the query from the model but doesn't let me due to the pending changes and ultimately results in an unusable .pbix

[FlowHawk]

Just ended up reverting to an earlier version and starting over essentially.

[cashcrane]

In case you ever run into it again. Here's what I did after some brute force chatgpting.

1. Open PowerBi, go to Settings & Options, Go to options , set Data Load to never preview preview download in background

2. Open the .pbix file in Safety Mode by 'Ctrl' + clicking

3. Accept the pending changes

4. Open transform data

5. Delete the troublesome query from the model

Worked for me! Hope it saves someone in the future.

[v-lionel-msft]

Hi @FlowHawk ,

Has your problem been solved?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FlowHawk]

No, we ended up assuming the PBIX was corrupted somehow and started with an earlier working version. No idea what happened.

[v-lionel-msft]

Hi @FlowHawk ,

There may be a problem with the data source of the table ‘Section1/LatestRefresh’. Please check whether this table can be refreshed normally(Right-click the table name of this table in the field bar.).

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg]

are you able to open it at all or does it kick you out?   How old is the report?

[FlowHawk]

The report is one month old. It allows me to click cancel, then proceeds with telling me every query has pending changes. Any idea why this would happen on a downloaded PBIX?