Forum Discussion
Power BI Online Visuals
Two tables in one of our Power BI reports aren't showing up in Power BI Online, but they are working fine in Power BI Desktop. I've attached a screenshot below, with Online on the let and Desktop on the right. All of the data is directly/automatically pulled from our system, no one goes into the data tables, so its not an error caused by changing a column name. I've tried refreshing and republishing the Desktop but that has not worked. Any thoughts. I've also included a copy of the error message.
Thankyou, Deku , for your response.
Hi Alexolsen151,We sincerely appreciate your inquiry through the Microsoft Fabric Community Forum.
Kindly follow the steps mentioned below, which may help resolve the issue:
-
Determine whether ID_ITEM (clusters) is a calculated column or a measure. If it is a measure, please verify whether it depends on a column that is missing in Power BI Service.
-
Navigate to Power BI Service → Dataset → Refresh History and review any errors. Additionally, try manually refreshing the dataset in Power BI Service instead of relying solely on scheduled refresh.
-
If your data originates from an on-premises source, ensure that the on-premises data gateway is running and correctly configured.
-
Ensure that all tables and relationships are properly defined in Power BI Service. Additionally, confirm that the user accessing the report has the necessary permissions to view all required tables within the dataset.
-
If you are using DirectQuery, consider switching the mode from DirectQuery to Import. Thereafter, publish the dataset again and verify whether this resolves the issue.
If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
Thank you.
-
5 Replies
v-pnaroju-msftCommunity Support
Thankyou, Deku , for your response.
Hi Alexolsen151,We sincerely appreciate your inquiry through the Microsoft Fabric Community Forum.
Kindly follow the steps mentioned below, which may help resolve the issue:
-
Determine whether ID_ITEM (clusters) is a calculated column or a measure. If it is a measure, please verify whether it depends on a column that is missing in Power BI Service.
-
Navigate to Power BI Service → Dataset → Refresh History and review any errors. Additionally, try manually refreshing the dataset in Power BI Service instead of relying solely on scheduled refresh.
-
If your data originates from an on-premises source, ensure that the on-premises data gateway is running and correctly configured.
-
Ensure that all tables and relationships are properly defined in Power BI Service. Additionally, confirm that the user accessing the report has the necessary permissions to view all required tables within the dataset.
-
If you are using DirectQuery, consider switching the mode from DirectQuery to Import. Thereafter, publish the dataset again and verify whether this resolves the issue.
If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will assist other community members facing similar queries.
Thank you.
-
Hi Alexolsen151 ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi Alexolsen151,
we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.Thank you
Regards,
Prasanna kumar
Hi Alexolsen151,
Just a gentle reminder — has your issue been resolved? If so, we’d be grateful if you could mark the solution that worked as Accepted Solution, or feel free to share your own if you found a different fix.
This not only closes the loop on your query but also helps others in the community solve similar issues faster.
Thank you for your time and feedback!
Best,
Prasanna Kumar
