Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 Po...
Need Help
dax's avatar
dax
Icon for Community Support rankCommunity Support
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
    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