Nice, thank you for overview of Composite model, Many-to-Many relation, Storage mode. I hope more detail movies each feature, and real scenario.
@gFowmy
6 жыл бұрын
Thanks Reza I was able to get some of my questions answered from this video.
@JamesManjackalMSFS
6 жыл бұрын
When I am using an streamed dataset then I cannot add any other souces of data to my reports, and I cannot create any relationship... Do you know if this issue changes using these composed models?
@RADACAD
6 жыл бұрын
The streaming dataset is totally different in the structure, you cannot create a composite model for streaming dataset. it is only for DirectQuery at the moment. if you want to bring more data fields into a streaming dataset, you need to combine all in one table and send them through you JSON entry from application code.
@shreyaprasad6350
4 жыл бұрын
Can we create relationship/join these two tables based on multiple columns?
@fredrikchristiansson2663
4 жыл бұрын
Hi, I have the latest version but can not find the feature?! Version: 2.75.5649.582 64-bit (november 2019). Any ideas? Thank for your clip.
@RADACAD
4 жыл бұрын
You can see this option, when you use a DirectQuery source, and then also Import data from another (or the same) source. then your mode will change to Mixed Mode.
@victorarayal
6 жыл бұрын
Great! What about DAX? It would be possible to use all the power of DAX? Or the same limitations with direct query? do you know?
@RADACAD
6 жыл бұрын
You can create a calculated table, and measure. you can also create a calculated column in Import data tables. those DAX calculations that use DirectQuery tables, will need to set the ability to have "unlimited DAX measures in DirectQuery mode" in Power BI options. However, it is not recommended, as it may put heavy queries on the data source.
Пікірлер: 9