Forum Discussion
Helper IIPower BI Report refresh Table name not showing up
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
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!
3 Replies
- Natarajan_M
Super User
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! 
v-echaithraCommunity Support
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.- 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.