Forum Discussion
Advocate IHow to view er diagrams(open data model)
Hello Lora_0121,
Yes, when using an Excel file from SharePoint as your data source, the "Open data model" feature in Power BI Service is typically unavailable. This is because Excel-based datasets often don’t create a full semantic model, especially with flat tables or when sensitivity labels are applied, which can restrict advanced modelling features like the ER diagram view.
Kindly refer to the below documentation links for better understanding:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources
https://learn.microsoft.com/en-us/power-bi/transform-model/service-edit-data-modelsTo confirm, you could test by creating a simple semantic model in Power BI Desktop using a non-Excel source like a manually created table or SQL data and publish it. The "Open data model" feature should then work.
Hope this helps if you have any queries we are happy to assist you further.
Thank you
Hi Lora_0121,
I would also take a moment to thank ibarrau, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Regards,
Harshitha.
Hi Lora_0121,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.
Regards,
Harshitha.Hi Lora_0121 ,
I wanted to follow up and see if you have had a chance to review the information that was shared. If you have any additional questions or need further clarification, please don’t hesitate to reach out. I am here to assist with any concerns you might have.
Regards,
Harshitha.