Power BI Report refresh Table name not showing up

[sanjyot_firke]

Hi Everyone,

We have reports getting refreshed on a hourly basis. However, recently we have started to receive warnings on those refreshes. When we look at the warning we find that there is no table name mentioned in the warning. Is there a way where we can find which table is getting referred to in the warning?

Regards

[v-echaithra]

Hi @sanjyot_firke ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-echaithra]

Hi @sanjyot_firke ,

Thank you @Natarajan_M  for your inputs.
We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

Thank you.

[Natarajan_M · Accepted solution]

Hi @sanjyot_firke ,

not sure why in service instead of showing the column and table name its showing the object id .

This is a warning we can neglect it also this warnign is also reported by other  users .. I think its a bug ..
To resolve this we can load the model in tmdl view and check which sort by column is causing the issue.

e.g :
I'm sorting the Sales label on sale id 

in tmdl view :

in dax studio we can get the column name using the id ;
SELECT * FROM $SYSTEM.TMSCHEMA_COLUMNS WHERE [ID] = 212;

Thanks 
If you found this helpful, please consider giving it a kudo and marking it as the accepted solution — it goes a long way in helping others facing the same issue.

For more Power BI tips and discussions, let’s connect on LinkedIn:
https://www.linkedin.com/in/natarajan-manivasagan

Cheers!