In this article, we will go over accessing Power BI Semantic Models in Excel. More specifically, we will discuss the prerequisites, the experience, and troubleshooting access in Excel.
This article contains the following topics:
Prerequisites
You must meet these requirements before accessing Power BI Semantic Models in Excel.
- You must have an active Fabric license. More details on Fabric Licenses: Power BI Licenses.
- You must exist as a user in Catalyst and have valid permissions to access the cube. Learn more about Managing Users and Permissions in Catalyst.
- Ensure you have the Excel Add-in Installed and Enabled. More details: EBM Excel Add-In: Installation Instructions
- Ensure the cube is properly set up and accessible.
The Experience in Excel
What to expect with cubes utilizing Power BI Semantic Models in Excel.
Cubes built on Power BI Semantic Models provide a seamless and familiar experience to the past. For users, aside from the prerequisites above, there is virtually no difference to how you access and interact with the cubes.
Downloading a cube file directly from the website continues to establish the connection for you. You may also continue to utilize the EBM Excel Add-in to quickly insert new cubes into your file.
Troubleshooting
Tips for resolving common issues when accessing Power BI Semantic Models in Excel.
Analysis Services Wizard
- Verify your Fabric license is active and ensure you have met the prerequisites above.
- If the instance was created recently or you are a new user, please close the file and try again.
- Ensure you still have the EBM Excel Add-in enabled. More info on EBM Excel Add-In: Troubleshooting
If you continue to experience issues, please reach out to EBM Support and submit a request.
FAQ's
Frequently Asked Questions (FAQ's) about Power BI Semantic Models and how EBM uses them to improve the user experience.
Q: What are Power BI Semantic Models?
A: Power BI Semantic Models are a new backend technology from which EBM Cubes can be built on. They allow for continued seamless access with Excel and improved access within Power BI.
Q: How do I know if my cube is using semantic models?
A: Right now, the best way for you to know if you're cube / instance is using semantic models is to access the admin of your instance.
In conclusion, utilizing cubes built on Power BI Semantic Models continues to make the data analysis experience quick and easy.
Comments
0 comments
Article is closed for comments.