Cannot load a pbix or access my queries (due to expired API token?)

[BPTBPTBPT]

Hello,

I have created a simple report with data from a website, which I retrieved via a token. I had to login in and the system gave me a temporary token, which I used to retrieve data in my Power BI report.

That was a few days ago. I think the token is valid for 1 day.

When I load the pbix now, it says:

Which translates to: 

There are changes in progress in your query that have not been applied yet

and

One or more calculated objects must be renewed manually.

The first one ("there are changes..") gives me this when I apply changes:

(it says that I don't have access to the token),

The bottom notification ("one or more....") does nothing when I click it.

There are no fields:

So, what do I do? It seems like I cannot load or edit the model.

My plan was to load the pbix, and then just manually change the token to a new one. But I cannot access the query right now!

My questions: 

• How do I access the query?
• And if someone knows a way to automatyically refresh the token somehow, that would be nice.

Thanks!

[v-zhangti]

Hi, @BPTBPTBPT 

About the automatic refresh token, you can refer to the following document, hope it can help you.

https://docs.microsoft.com/en-us/javascript/api/overview/powerbi/refresh-token 

https://community.powerbi.com/t5/Power-Query/Refresh-token-api-call/td-p/937553 

Best Regards,

Community Support Team _Charlotte

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

[BPTBPTBPT]

Hi, anyone that can help me out?