Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
we are part of global organization where we have Azure SSAS tabular model and each country has there own BAs who connects to SSAS using PowerBI and build their as-hoc reports.
Issue is,
1> SSAS Live connection does not allow mulitple sources and users are not able to do their final report where they need to add some customer name for products as per their market and other connection to excel etc.
2> Each country as slightly different requirements on fields which can be dimension or measurues.
How do you design or build or meet this kind of requirements when keeping one global SSAS Model for all the countries ?
Appretiate any feedback or references or ideas !! 🙂
Thanks,
Tej
hi, @Anonymous
For you are part of a global organization, I suggest you customize a uniform template for data model.
Live connection does not allow mulitple sources, you could use import the dataset. for each country as slightly different requirements on fields, you could create different measure.
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
105 | |
97 | |
79 | |
66 | |
62 |
User | Count |
---|---|
145 | |
113 | |
105 | |
85 | |
65 |