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.
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?
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.
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.
Nice, thank you for overview of Composite model, Many-to-Many relation, Storage mode.
I hope more detail movies each feature, and real scenario.
Thanks Reza
I was able to get some of my questions answered from this video.
Can we create relationship/join these two tables based on multiple columns?
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?
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.
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?
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.
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.
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.