Forum Discussion

sanjyot_firke's avatar
sanjyot_firke
Helper II
5 months ago
Solved

Power 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...
Need Help
  • Natarajan_M's avatar
    Natarajan_M
    5 months ago

    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!

     

Natarajan_M's avatar
Natarajan_M
Super User
5 months ago

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!