Forum Discussion
Power BI Dataset for Measures
Hi Team,
We are developing a number of Power BI reports using Snowflake as the data source. This is a migration project and we are migrating from OLAP cubes with excel reporting to Snowflake with Power BI reporting. IIn Snowflake we are storing the data in Star Schema with Facts and dimesions. Business users are required to create adhoc reports connecting to this Star schema. However the business users are more used to working with the measures for reporting as they were having in the cubes. Would it be a good approach to create Power BI datasets with the required business measures and publish that data set so that business users can connect to this data set to create their adhoc reports. Would there be any limitations in this approach(like in publishing the report to the service etc..)
2 Replies
Hi hebavarkey,
In your scenario, did you wonder whethet the cube measure could used in PowerBI, right? If so, as I know the measure in SSAS cube could used on PowerBI. If you want to use OLAP cube(which have measure in it), you could try to connect to your source(SSAS) and use measure field in report directly.
Best Regards,
Zoe Zhi- Thank you Zoe Zhi. Right now we have snowflake as the data source and are moving away from cubes. The snowflake is in star schema with facts and dimensions. However the business users woul need to do ad-hoc reporting on their own. They are more used to a cube kind of measures and that's where we want to explore the possibility of creating a power bi data set with measures. We were thinking of publishing this data set so that all other business users can connect to this data set and create their own reports. Wanted to check if this is right approach and are there any Limitations associated with the approach
