My PBI unable refresh , what else I should try ?

[admin11]

Hi All ,

I have develop a PBI file for 2 year ago . Now when I try to refresh . I will get error. I already spend more then 3 day I still unable figure out where go wrong ? Can some one suggest to me What else I should do , beside I start to create a new PBI file from zero ?

Paul

[mahoneypat · Accepted solution]

Go into the query editor and click the Applied Steps one at a time in each query (if more than one), and share the error you see if the first step that returns an error.

Pat

[mahoneypat · Accepted solution]

Go into the query editor and click the Applied Steps one at a time in each query (if more than one), and share the error you see if the first step that returns an error.

Pat

[admin11 · Accepted solution]

@mahoneypat 

Many thank for your reply to my post . You are great. after i load the PBI file , i go to PQ editor , after few minute , i notice that some of the table load some are not loading. So what i did is i delete those table which unable to load , and clear all the error , i am am able to refresh. so meaning i have hope now. i don't have to start to zero , and can take those back up file whch is last week , and i just need to do the above step , it will save me a lot a lot of my time to add table.

Appreciate very much. To night i can finally have a good sleep. 

I owe you a lot.

Paul