query connection changed, shows table doesn't exist in measures

[thanksforhelp22]

Hi,

I am really exhausted with this PBI report, developed by another user and I am trying to change the connection and refresh the data. there around 22 - 4 millions records in each query. so refresh is for ever. but finally succeed in all changes and refresh. then found the model query joins was deleted, so enabled all the joins. But till says in measures that one of the table doen't exist. there was no name change.  any pointer will be helpful that I am missing. Also, is there a way to open ticket with MS for PBI support. I know is not possible to get all solution in the support community. 

[v-yiruan-msft · Accepted solution]

Hi @thanksforhelp22 ,

If you get the pbix file for the related report, please open it in Power BI Desktop first. Then follow the steps below to make troubleshooting and try to find the solution:

• Find all measures which got the error
• Make sure if the error of the above measures were caused by some one speicific table doesn't exist
• Chekck if that table exist in your model:
  • if yes, please refer this blog to clear the cache and edit the permissions. After done all, please check if the error still exist;
  • If no, check if the table exist in the data source exactly.

If the above ones can't help you get the solution, please provide the above findings and the screenshot of meaures with error message. It would be helpful to find out the solution. Later we will check it and give you a suitable solution. Thank you.

Best Regards