Unboxing new Power BI composite models

Ғылым және технология

Пікірлер: 231

  • @vickarkhan
    @vickarkhan3 жыл бұрын

    Your emphasis on this feature being historical just made me more excited to watch the rest of your video. Thanks for that, Alberto.

  • @johankoopmans6561

    @johankoopmans6561

    3 жыл бұрын

    It is not so historical . Strategy companion analyzer already has this "recombinant bi" feature since 2013 which also works on multidimensional models

  • @hanantoprabowo7341
    @hanantoprabowo73413 жыл бұрын

    The best explanation so far regarding this awesome feature! I always like Alberto's and Marco's style to dig deeper into new stuffs and to analyze its strengths and weaknesses! Thanks a lot Alberto!

  • @SaniGarba
    @SaniGarba3 жыл бұрын

    For me, this provides the best clarity to this highly-anticipated improvement to Power BI. Thank you.

  • @pmsocho
    @pmsocho3 жыл бұрын

    "Hurry up, don't change everything today but start learning because this is really going to change the way you look at your business models" :) Thanks for the video!

  • @Milhouse77BS
    @Milhouse77BS3 жыл бұрын

    Glad I woke up early. At 5:37 good tip on creating sort column with DAX.

  • @amarines2
    @amarines23 жыл бұрын

    As always your manner of how you explains are incredibly clear. So excited on how and where apply this

  • @albertoortega98
    @albertoortega983 жыл бұрын

    Amazing! Really interested to implement this, having a full enterprise model managed by global IT teams and allowing local teams to extend the model as they need. Thanks a lot for this video with a very good explanation and demostration of this feature!

  • @sue_bayes
    @sue_bayes3 жыл бұрын

    Thank you, this has really helped understand the potential and how to start to explore the best practise in using the new features. This is game changing and what so many businesses have been asking for.

  • @louism.4980
    @louism.4980Ай бұрын

    Always enjoy watching your videos, thank you for the demo! :)

  • @mikar636
    @mikar6363 жыл бұрын

    Amazing SQLBI Team!!! Thank you for sharing all these videos!!!

  • @atiry839
    @atiry8393 жыл бұрын

    How your explanation this much smooth and simple. thank you Alberto.

  • @diegonoliveira
    @diegonoliveira3 жыл бұрын

    We are waiting this for a long time. That’s really awesome Alberto. Thank you for helping us understand and study this feature.

  • @Bzuhl
    @Bzuhl3 жыл бұрын

    This come just as we got the go for attempting full coverage of our BI with SSAS, I'll be looking forward to the new best practices for tabular models to take advantage of it!

  • @terryliu3635
    @terryliu36353 жыл бұрын

    Great step by step on ABC analysis!

  • @aleksanderstrommer7677
    @aleksanderstrommer76773 жыл бұрын

    It is great to see you ENJOYING DAX!

  • @VladMZ
    @VladMZ3 жыл бұрын

    This is the killer feature. Sorry to bring up OBIEE again, but inability to standardize your organization's semantic model was a HUGE drawback of Power BI in comparison with the industrial BI solutions such as OBIEE and Cognos. THIS solves this problem. It is now that we can finally separate metadata stewardship to more qualified analysts and deevelopers, but keep the Power BI's unmatched front-end flexibility in hands of advanced users. Separation of duties is a big thing in large companies.

  • @ranjanmehta100
    @ranjanmehta1003 жыл бұрын

    Thankyou so much for the explanation. It is very useful and now I can use my semantic layer datamodel with local model. kudos

  • @mohammedadnan2147
    @mohammedadnan21473 жыл бұрын

    Enjoy Power BI... Really very well detailed explanation.. thank you so much...

  • @saurabhsurve6152
    @saurabhsurve61522 жыл бұрын

    Amazing video. Very clear explanation. Grazie mille !!

  • @Kevin-ex9vr
    @Kevin-ex9vr Жыл бұрын

    this guy is a solid unit of eloquence and presentation skills. you are a master on your craft sir.

  • @samikpal3583
    @samikpal35833 жыл бұрын

    This is just mind blowing. Simply by using this feature my model size reduced from 185 MB to 4MB

  • @MaurizioFaini
    @MaurizioFaini3 жыл бұрын

    Awesome! This is what I'm waiting, this is what all my end users are looking for. I love this huge update. Thank you Alberto for this video.

  • @alessandroculotta5505
    @alessandroculotta55053 жыл бұрын

    Grande Alberto! Great news from MS and great video. Moreover your public speaking skills are improving at best level. TOP!

  • @analistax
    @analistax2 жыл бұрын

    OMG... I love your videos. Just now i can see the importance of this model. Thank very much for this video.

  • @raz8657
    @raz86573 жыл бұрын

    Amazing feature from MS and wonderful explanation by my friend 👏

  • @jasonwoodward5501
    @jasonwoodward55013 жыл бұрын

    Excellent. Thank you.

  • @salosteysv
    @salosteysv3 жыл бұрын

    Great! I've been waiting for this for years )

  • @RobertoAgnello
    @RobertoAgnello3 жыл бұрын

    Amazing!

  • @maicopresente
    @maicopresente3 жыл бұрын

    Super Interessante! Grazie Alberto!

  • @julliaraujo
    @julliaraujo3 жыл бұрын

    Great video! Is there any chance to get a video about connecting to datasets from different workspaces and the data gateway settings? Thanks a lot

  • @TheMer1122
    @TheMer11223 жыл бұрын

    Whoa, that's awesome total shift

  • @joseluisbeltramone599
    @joseluisbeltramone5992 жыл бұрын

    Grazie mille for the excellent explanation!

  • @kishore_p93
    @kishore_p933 жыл бұрын

    This is huge!

  • @eduardomunoz2764
    @eduardomunoz27643 жыл бұрын

    Wonderful explanation. Greetings and thank you very much

  • @HugoVenturini
    @HugoVenturini3 жыл бұрын

    Bravo! Bravíssimo, Alberto!!!!! I'm so exciting too...thank you and Marco!

  • @ChrisBilsoe
    @ChrisBilsoe3 жыл бұрын

    Great video Alberto. Any thoughts on how calculation groups would work when combining two datasets? Fx a main dataset with sales and calculations for time intelligence, combined with website data wanting the same time intelligence calculations

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    Unfortunately... it depends! It's one of the many topic we have to cover in future articles and videos (and we don't have the full answer yet!).

  • @aeimei
    @aeimei3 жыл бұрын

    Just a BIG WOOOOW.....Reusability, conformed Fact feature on enterprise level is almost there. Very excited!!

  • @2404Pepe
    @2404Pepe3 жыл бұрын

    WOW!!!! thanks Alberto!!! just what I needed!!! thanks so much for you grat videos

  • @loretta6587
    @loretta65873 жыл бұрын

    Thank you Alberto for your great demo. Do you know whether it will support connection between multiple Analysis service by any chance?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    Only Azure Analysis Services. Analysis Services on-premises is not supported. They could support in the future but deploying a big update to the on-premises version (perhaps, SQL vNext?).

  • @divyakulkarni6136
    @divyakulkarni61363 жыл бұрын

    Great video, Is it possible to apply RLS when using direct query on analysis server using a calculated column?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    Yes, it is supported, but the security is not fully implemented as of today (April 2021) - it should be fine at GA.

  • @muhammadrahman3510
    @muhammadrahman35102 жыл бұрын

    This is a great video! Please have more videos like this. If you could do in regards to DAX as well :) Thanks so much!

  • @KayMuslimeen
    @KayMuslimeen3 жыл бұрын

    Thank you Alberto for this amazing demonstration! Off-topic: what is the model of the microphone you're using? I find it really convenient for recording screencast videos.

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    Hi Kay, I am still testing several ones. Because I have seven monitors in front of me, there is a lot of echo coming back and I need an very close mic. In this video I am using a PROEL condenser mic (HCM23SE) even though I am not really satisfied with the audio results. I plan to experiment with different headsets in the next weeks... I am in the process of learning the secrets of audio tuning! :)

  • @pedrosanteloy
    @pedrosanteloy3 жыл бұрын

    Awesome! Just one thing, what All() does? It remove the filters that are being applying automatically?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    ALL is like REMOVEFILTERS; more details here: www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept/

  • @ameyraj4947
    @ameyraj49473 жыл бұрын

    Awesome🎉🎉

  • @yusufbas035
    @yusufbas035 Жыл бұрын

    I want to watch all of the man's videos.

  • @giuliobontadini
    @giuliobontadini3 жыл бұрын

    I would normally connect to DataFlows instead of DataSets precisely because this seemed the only way to add other tables and relationship (with the drawback of having to start with no base-model at all each time). This new feature does sound revolutionary! Then the question is: are there any use cases left for DataFlows?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    Whenever you want to separate the transformation from the data model. For example, you can easily have a Product table share in many datasets. If the transformation is complex, you can keep it in a single place using a dataflow.

  • @joaquinmaverick82
    @joaquinmaverick823 жыл бұрын

    great video!!! I have a few questions... where is stored the data from excel? is stored in a new power bi dataset? or you have to upload the new composite model as a new dataset publishing it?

  • @jeffkasavan93
    @jeffkasavan933 жыл бұрын

    That is mind blowing! Grazie mille!

  • @RonaldPostelmans
    @RonaldPostelmans3 жыл бұрын

    Thanks for this, i was looking for the part of the running totals with percentage that way a long time. Can you tell me how you can filter this? if i add a filter on a different column the filter does nothing, it only filters when adding a column to the filter which also contains the added calculated columns for the running total calculation.

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    You might want to read these: www.sqlbi.com/articles/computing-running-totals-in-dax/ www.daxpatterns.com/cumulative-total/

  • @justinogarcia3705
    @justinogarcia37053 жыл бұрын

    This is a great feature. Que bueno.

  • @andrewevans5750
    @andrewevans57503 жыл бұрын

    Sounds like they took a look at Apache Superset. That or Quicksite. Also

  • @powerbinareal
    @powerbinareal2 жыл бұрын

    Sempre top! #vivadax

  • @triparnaray
    @triparnaray3 жыл бұрын

    Hi Alberto, Thanks for the excellent presentation on the new feature. What happens when business users need to reflect their data just updated in SQL (storage model) to power bi report? as you recommeneded semantic layer refreshing, power bi shared dataset can only be refreshed once in 30 mins unless done externally or you prefer to connect to analysis services and it connect to sql by direct query and power bi connects to it. please let me know your thoughts.

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    It really depends. You can refresh quicker with Power BI Premium, using DirectQuery has a big impact on performance and usually it is acceptable having some latency because of the refresh obtaining better scalability and response time. If you really need real-time data, you have to use DirectQuery, but you should be aware of the issues in data consistency in the report (if you run a report during a refresh, you can get different numbers in visuals that should provide the same measure in the same report, for example a line chart and a table). Real-time update is a tough business.

  • @futureanalytics5774
    @futureanalytics57743 жыл бұрын

    Thats a Game changing feature is it possible for SAP HANA Direct Query as well or is it only for Analysis for services?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    Only Power BI datasets and Azure Analysis Services databases. But you can publish and connect to a Power BI Dataset connected to SAP HANA, of course!

  • @rjarpa
    @rjarpa3 жыл бұрын

    Amazing!! I was awaiting a lot my end user will stop hear "We can't include that shitty local Excel file in our robust model enterprise model. Even that is important for you."

  • @J0schua
    @J0schua2 жыл бұрын

    Thanks for this overview of this amazing new feature. I would like to only use 1 table from my cloud model. It is a calculated table that aggregates the „result“ of my cloud model in just the right granularity. Until now I just exported this table as an excel table using DAX Studio and importing it in my local model that works with this result. At first composite models seemed to be a much more elegant solution for this scenario. Testing it though I always have ti import the intire cloud model with all the table and all the complexity. This also crowds up my local model with a lot of tables that i do not need. Any advice on best practises here ?

  • @SQLBI

    @SQLBI

    2 жыл бұрын

    Try the last version of Power BI Desktop: you can select the tables to include. Hint: create a local table first, then connect to the external model. At this point you can select the tables to import.

  • @nithinshankar866
    @nithinshankar8663 жыл бұрын

    First time I hear from you "Not interested in Performance " 😂

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    Well well well... I said "I am not interested in performance" :) Actually, testing performance is kind of hard in this scenario... I am working on it!

  • @nithinshankar866

    @nithinshankar866

    3 жыл бұрын

    @@SQLBI yep ur right 🙂

  • @dsfshshfhgsghs
    @dsfshshfhgsghs2 жыл бұрын

    Tante grazie, Alberto!

  • @viniciusfernandes3552
    @viniciusfernandes35523 жыл бұрын

    Break through indeed

  • @Bharath_PBI
    @Bharath_PBI3 жыл бұрын

    This is really huge, tried it since yesterday and really feeling amazed. After going through the documentation, came to know that 3 chain of model is the limit in preview. Now if we think of an organisation and multiple analysts creating their own model on top of enterprise bism, will it deviate from golden dataset!? And will the admin be able to control the publishing of these local models? Thank you for taking up this. So this brings up lots of questions related to data Island, weak and strong relationship and other existing modeling and DAX concepts (will it continue to behave same as existing). Curious to learn about this.. will look forward for things around DQ against semantic model.

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    We are just at the beginning and there are bugs and lessons to learn. Moreover, the feature is in preview, expect changes before its release. In general, we think that easy tasks like importing an Excel file, creating an additional calculated column and renaming a measure will not have particular issues. Creating mash up with two or more models and adding complex relationships between models, interacting with calculation groups,, managing security (not supported in this first preview)... well, that's another story. We need to try, study, and learn.

  • @Bharath_PBI

    @Bharath_PBI

    3 жыл бұрын

    @@SQLBI Yes agree, this is just the beginning and lot more things will be coming out of the box. Many things to learn on the way. Appreciate it and welcome the New beginning.

  • @cecinati

    @cecinati

    3 жыл бұрын

    @@SQLBI Thanks a lot Alberto! Can we immagine to create different models that can interact within each other in a modular way? What do you think about provide the user with simple models that he can compose in a scalable way? Does it overlap the dataflow concept?

  • @gsanchez7124
    @gsanchez71242 жыл бұрын

    hi what about combining two sap sources both through Directquery?

  • @kredeker54
    @kredeker543 жыл бұрын

    Are we able to mix a table created using the direct query method in a pbix that references a data model in SSAS?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    SSAS is not supported yet, only Power BI datasets and Azure Analysis Services.

  • @strafanich
    @strafanich3 жыл бұрын

    Love this new feature, but it leaves me wondering a bit. Doesn't this pretty much make dataflows obsolete already? Why should I use a dataflow instead of this solution?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    A dataflow split the business logic of a transformation from the dataset. It could be useful to reuse the same transformation logic in different models. A dataset is table+relationships+mesures, it's a more high-level concept. If you used dataflows as a way to share tables between datasets, yes, you used a temporary solution and this is better. However, you might end up having the need of reusing the same table (dimension?) in different datasets (connecting a dimension in one dataset to a fact table in another dataset is intuitively a bad idea, even though we have to practice to evaluate pros-cons). Thus, you might still want to use dataflows. Each tool is a just tool. It doesn't have to be used just because it exists, but when it's useful!

  • @frankief7111
    @frankief71113 жыл бұрын

    Nice explanation, thank you. What if you publish this model, can you connect a composite model to it and then publish that and on and on and on...

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    There should be a limit on the number of indirections, it seems it is two or three by the first tests we made but it could change and we didn't run extensive tests yet.

  • @frankief7111

    @frankief7111

    3 жыл бұрын

    @@SQLBI Thanks. I like the idea of being able to distribute load (and hence costs). If you have 3 servers making up a composite model you could make it so the more accessed parts of the model reside on the highest tier server and data that you are happy to wait for can be on the lowest cheaper tier. From the user experience point of view there is still only one connection point and it presents as massive integrated model that still performs where needed.

  • @RKTECH1021
    @RKTECH10212 жыл бұрын

    This is a cool feature, does this create a brand new model on top of existing analysis model in Power BI. means it also needs to be refreshed frequently for any dataset (Excel, SQL server etc) added by user.

  • @SQLBI

    @SQLBI

    2 жыл бұрын

    The new model links the existing one. You need to refresh it only if you *also* import other tables, otherwise no refresh is required.

  • @UU-ry6gt
    @UU-ry6gt Жыл бұрын

    After 2 years, would be great to get an update on this topic ;)

  • @SQLBI

    @SQLBI

    Жыл бұрын

    You can find free content (including videos) from this list: www.sqlbi.com/topics/composite-models/ And more content on SQLBI+: www.sqlbi.com/p/plus/ www.sqlbi.com/whitepapers/composite-models/

  • @reuvainkrasner7879
    @reuvainkrasner78793 жыл бұрын

    What is the performance difference when connecting to a model as a live connection vs Direct Query?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    We use "new composite models" to remove the ambiguity with "DirectQuery for relational data sources". When you connect to a published dataset with a new composite model (officially "DirectQuery for Power BI dataset and Analysis Services") you can expect the same performance of Live connection, which is orders of magnitude better than "DirectQuery for relational data sources" (like DirectQuery for SQL Server).

  • @br31woodlands69
    @br31woodlands693 жыл бұрын

    Thank you much

  • 3 жыл бұрын

    Excellent video on an excellent new feature of Power BI, indeed! I am also grateful for all the tutorials you are creating and sharing. However, my question refers to the ABC classification example. I have a model where I have a product table (16 k rows) and another table with locations (cities) belonging to different countries, countries belonging to different business units (1 BU could be 1 country, but there are cases where 1 BU means 4 countries together). What is your advice to have ABC classification that would respect the filtering by country and/or by BU? If I add calculated columns to the product table as you suggested I would not get correct classification. Many thanks for the feedback!

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    I suggest you taking a look at the ABC Analysis pattern at daxpatterns.com. There, you'll find plenty of options. In your case, I think you will like the dynamic ABC, or the snapshot ABC. Both should work well in your scenario

  • 3 жыл бұрын

    @@SQLBI Many thanks for the feedback and tip. It looks like the snapshot ABC would be best option for me so I would spend some time to read it carefully and implement it. Mille Grazie!

  • @dariuszspiewak5624
    @dariuszspiewak56243 жыл бұрын

    Alberto... as with any new features... I just wonder what the TRAPS are :))) But at least your work is guaranteed and new books as well :)))

  • @sands7779
    @sands77793 жыл бұрын

    more power for self service, good news for analysts

  • @LuisSanchez-dw7hv
    @LuisSanchez-dw7hv3 жыл бұрын

    Thank you so much for this amazing video. I would like to ask if it is now possible to create dax intelligence functions with this composite models.

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    It was already possible to use time intelligence functions in other models - can you elaborate?

  • @LuisSanchez-dw7hv

    @LuisSanchez-dw7hv

    3 жыл бұрын

    @@SQLBI i mean i know is not possible to use time intelligence functions with DQ. My questions is: is it possible to use time intelligence functions with a model that has DQ and import mode?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    You CAN use time intelligence functions with Direct Query (docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about). You just have to add a Date table to the model, which is a best practice for any model. See kzread.info/dash/bejne/dK6m19OrmpDdiso.html and kzread.info/dash/bejne/qqln16Z-eNeposo.html

  • @renatofreitas3877
    @renatofreitas38773 жыл бұрын

    Very good tips Alberto, Thanks a lot. Just one question. Can we join datasets with this feature? Lat's play with that.

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    The notion of "join" in DAX is ambiguous... yes, you can create relationships between tables coming from different datasets if this was the question.

  • @xpaulone
    @xpaulone3 жыл бұрын

    Great! What happens if i connect 2 dataset with their own date table (to simplify with the same structure)? Remove one table and recreate the relationship or create a bidirectional relationship between the two?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    It's too early to say. We are experimenting. There are several pros-cons in each scenario and there are so many combinations: - local copy of Date connected to the two Date tables in remote datasets - use one Date table and hide the other, using a single-direction filter - show both Date tables and create a one-to-one relationship (bidirectional) On top of these solutions, you have the options of the granularity of the relationship between datasets: Date, Month, Year? It depends, you have to balance granularity of analysis with performance. At the beginning, start with simple things, like adding a local table or a calculated column. Mash up of two or more remote datasets in unexplored territory, nobody has experience to define best practices.

  • @xpaulone

    @xpaulone

    3 жыл бұрын

    @@SQLBI as expected, thank you!

  • @sensi4641
    @sensi46413 жыл бұрын

    Very informative. With this new feature (assuming it works as expected), does it mean that we don't need SSAS or even Azure Analysis services? We could take raw data (from ODS for example), build a virtual operational datamart, then load that data via import mode to Corporate Power BI Dataset (which might combine other datamarts) and make it available to business users? (especialy if one has Power BI Premium). Or would it make more sense to have a physical operational datamart and load it through direct query to Corporate Power BI dataset for further business usage? The last option doesn't make sense to me - but I might be missing things :) I am just trying to picture the enterprise data architecture with Power BI and ODS/Datamarts on MS SQL Server. Don't have plan to use AAS as plan to have PBI Premium.

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    It's still too early to say, but this tool is not a way to avoid ETL/data cleansing and a good architecture. You can certainly create reports integrating additional data, but creating complex mashups with multiple data sources is not a good idea. You would always pay a technical debt in data quality and performance.

  • @jaco7433
    @jaco74333 жыл бұрын

    Unfortunately the performance is really low when using dax between import tables and direct query tables

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    It depends on the cardinality of the relationships between different data sources. If you use a remote dataset (not a DirectQuery connection to SQL) the performance is relatively good in that case. DirectQuery over a relational database was, is, and will continue to be much slower.

  • @justinguo3980
    @justinguo39802 жыл бұрын

    Amazing Video Alberto! Learnt a lot from your videos as always. A question though, I couldn't figure out how the DAX of the ABC Amt RT calculated column works. Did a lot of research on the function but still couldn't figure out. Are you please able to explain a bit? or suggest any document I can read? thank you!!!

  • @SQLBI

    @SQLBI

    2 жыл бұрын

    See these patterns: www.daxpatterns.com/cumulative-total/ www.daxpatterns.com/abc-classification/

  • @charlesdelanoy
    @charlesdelanoy2 жыл бұрын

    Thanks so much for the video, I watched it when it first came out....and now again for the 3rd time ! Yes indeed a game changer, I wonder what your opinion is now that we are 10 months in from the first launch...would be great to understand your learnings, pros and cons.

  • @marounsader318
    @marounsader3183 жыл бұрын

    hi alberto, whats the shortcut you use to select the whole line while you write the DAX?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    If there is one, then I don't know it :) I just use SHIFT-ARROW DOWN at the beginning of a line to extend the selection to the next line.

  • @marounsader318

    @marounsader318

    3 жыл бұрын

    @@SQLBI when you copied the line in the switch function i noticed your cursor is on the last letter they you highlighted the whole line then pasted, is it shift+down arrow

  • @VladMZ
    @VladMZ3 жыл бұрын

    HOLY COW, I just built a report on TWO cloud datasets! It's slow, but it's working. Very promising feature! The bad things that will happen: all the display folders will be gone, naming conventions should be in place ( I still don't know what will happen in the naming conflict), and I couldn't find a way to disconnect from a dataset as they don't appear in the Power Query.

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    This is the first preview, there are a lot of bugs to fix... Wait before going in production, but you can already see the potential!

  • @bbbradl
    @bbbradl2 жыл бұрын

    Now in April 2022, I can appreciate how powerful this is because we seem to be denied it with Live Connect to SSAS and it's positively disabling. I'm stuck with the model's design, even for adding simple slicer columns such as Price Range. Am I missing something? Is there some option I need to enable? (HELLLLPPP!)

  • @TheMer1122
    @TheMer11223 жыл бұрын

    Can it connect to multiple cloud models?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    Yes!

  • @dhruvtaara
    @dhruvtaara3 жыл бұрын

    Excellent video... Just tried this with my model (using Dataflows). As soon as i enabled the DirectQuery i lost the date heirarchy in all of my date fields in the table. Does anyone know why this happened and can i fix this ?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    It could be a bug or not - the feature is new and in preview, there are knew limitations published in the release doc and there are probably several bugs. However, if you are using auto date/time (as it seems from the description), you should stop it now! :) See kzread.info/dash/bejne/dK6m19OrmpDdiso.html

  • @damn68
    @damn683 жыл бұрын

    What version of power bi desk top are using, because it doesn't work with my. I am using analysis service live connect and I can't add anything else. Like importing excel

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    SQL Server Analysis Services is not supported, you should connect to Azure Analysis Services or Power BI Dataset.

  • @PythonWithJoe
    @PythonWithJoe3 жыл бұрын

    just a big wooow

  • @chicagobassplayer7175
    @chicagobassplayer71757 ай бұрын

    After you pull in your own data and it is local, then do you publish it back up to your tenant? I have seen a bunch of videos like this and its great that you can do this but they never explain what to do after you merge the data. From what I understand, you just keep it local..?

  • @SQLBI

    @SQLBI

    7 ай бұрын

    The local data stay local. You can publish the second model to your tenant, but also in that case you still have two separate databases (they could be in different tenants - assuming you have authorization to connect).

  • @chicagobassplayer7175

    @chicagobassplayer7175

    7 ай бұрын

    @@SQLBI - Is that common to do that? You would need to publish the model to a different tenant? What happens if you publish back into the main tenant the connected data set was from? Would that add the Excel file to that data set? Thanks!

  • @JS-ts2vv
    @JS-ts2vv3 жыл бұрын

    Does this mean we can connect multiple dataset in one report?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    Yes!

  • @JS-ts2vv

    @JS-ts2vv

    3 жыл бұрын

    @@SQLBI awesome. funny as of today I could not see that capability when I clicked on transform only Datasource setting is enabled.

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    You need the latest version of Power BI Desktop and you have to click on "Make changes to this model" button in Modeling ribbon. If you don't see that button and you have Power BI Desktop December 2020, you are probably connected to a database that is not supported (only Power BI datasets and Azure Analysis Services databases are supported. Power BI Report Server is not supported).

  • @albertoortega98
    @albertoortega983 жыл бұрын

    Question: can it connect to an Azure SQL in DirectQuery? Thanks!

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    Yes, but that kind of DirectQuery access is not related to the content of this video.

  • @albertoortega98

    @albertoortega98

    3 жыл бұрын

    @@SQLBI I meant, create the local model connected in DirectQuery to analysis services as you did in the video, and then add a new connection in DirectQuery to an Azure SQL database, to join some tables, is it possible? Thanks!!

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    Yes, but you need to connect Azure Analysis Services. If you create a live connection to a Analysis Services on-premises, it is not supported.

  • @dacemangar9134
    @dacemangar913411 ай бұрын

    The composite model is great, but I cannot refresh the report as it has calculated tables and columns which seems to be a limitation when refreshing from powerbi service. Any help is appreciated.

  • @Dackel1972
    @Dackel19723 жыл бұрын

    This doesn't seem to work with cloud datasets in workspaces without dedicated capacity/power bi premium. Can you confirm this?

  • @Dackel1972

    @Dackel1972

    3 жыл бұрын

    sorry, I forgot to enable the preview feature in options. After doing this, it works against a dataset in a non-premium workspace.

  • @mathew9665
    @mathew96653 жыл бұрын

    Thank you so much Alberto - This is amazing - side question - SQLBI normally advise against using Many to Many, when you added the budget to the model and added the relationship, is there an alternative best practice or is this the time when it's acceptable to use Many to Many?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    In this case it is acceptable. However, we strongly advice to avoid the bidirectional filter. The many-many cardinality relationship with a single direction filter is usually good as long as you are aware of the side effects you have on measures used below the cardinality of the relationship.

  • @mathew9665

    @mathew9665

    3 жыл бұрын

    @@SQLBI Thank you, when you state below the cardinality of the relationship - I presume you mean further away from those tables - so if you have a fact table on your product and product budget, on one side of the model. The issue might start to appear if you want to look at the budget from another completely separate dimension table that holds not direct relationship to the product/product budget table?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    by different granularity I mean that with a many-to-many cardinal it’s relationship at the product category level with the budget, you cannot split by product name the budget (but you can split the sales by product name).

  • @mathew9665

    @mathew9665

    3 жыл бұрын

    @@SQLBI - I think I'm beginning to understand this point now. Is there any visual that I can look at to drive this home more simple. I feel this is very important point, and want to ensure I fully appreciate your comments

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    You can start here: www.sqlbi.com/articles/budget-and-other-data-at-different-granularities-in-powerpivot/ www.sqlbi.com/articles/working-below-a-dax-formulas-granularity/

  • @thiagopeixoto5070
    @thiagopeixoto50703 жыл бұрын

    I didn't work with me. Is it available with every type of datasets?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    You need the latest version of Power BI Desktop and you have to click on "Make changes to this model" button in Modeling ribbon. If you don't see that button and you have Power BI Desktop December 2020, you are probably connected to a database that is not supported (only Power BI datasets and Azure Analysis Services databases are supported. Power BI Report Server is not supported).

  • @AlbertoGastaldo
    @AlbertoGastaldo3 жыл бұрын

    Hi Alberto I guess direct query will also works against on premises Ssas tabular Am I correct ?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    You can only use live connections but you cannot use composite models with SSAS Tabular on-premises.

  • @TheMer1122
    @TheMer11223 жыл бұрын

    Can that then be pushed to the cloud?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    Yes!

  • @parpatigayatri6271
    @parpatigayatri62712 жыл бұрын

    Can we create a composite model making one dataset as live connection and another one as an imported table, but both the queries are fetching data from a single data source. For example Oracle database.

  • @SQLBI

    @SQLBI

    2 жыл бұрын

    Yes it should work.

  • @AutomationBIAI
    @AutomationBIAI3 жыл бұрын

    HI Alberto, thanks where can I download the budget file ?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    We don't have the files available for download, but they are very close to the this pattern: www.daxpatterns.com/budget/

  • @christineding9822
    @christineding98223 жыл бұрын

    my concern is that calculate column is quite heavy if your data table is over 1 million line , the function is cool but not so workable for real big data senario.

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    A column True/False is not that big, its cost in memory and processing time is moderate. I would be careful with 1 billion rows (or at least 100 million rows), definitely not with 1 million rows.

  • @AArora81
    @AArora813 жыл бұрын

    Thank you for this video. I'm unable to use this feature though. I just upgraded my Power BI desktop version to December 2020. I connected to a model in Live mode but when the "Transform data" button remains disabled. Could you please advice, am I missing anything?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    Did you connect to Analysis Services on-premises? It only works with connection to Power BI Datasets and to Azure Analysis Services. You should also see a button "Make changes to this model" and a link in the bottom right corner (we prepared the video with a preview). Watch MS announcement, too: powerbi.microsoft.com/en-us/blog/power-bi-december-2020-feature-summary/#_Toc58831296

  • @nlagreste

    @nlagreste

    3 жыл бұрын

    Try enabling the option: "DirectQuery for Power BI datasets and Analysis services" in the Preview feature section.

  • @AArora81

    @AArora81

    3 жыл бұрын

    @@SQLBI sorry didn't realize I have a response here. Apparently needed to enable this feature in preview features section in Power BI Desktop.

  • @AArora81

    @AArora81

    3 жыл бұрын

    @@nlagreste Thank you. This was the missing part. It worked.

  • @omersacakli5397
    @omersacakli53975 ай бұрын

    Is it possible to use the composite models in the Power BI report server?

  • @johnledyard2320
    @johnledyard23203 жыл бұрын

    What is that text slicer he is using at 10:20?

  • @SQLBI

    @SQLBI

    3 жыл бұрын

    Smart Filter Pro: okviz.com/smart-filter-pro/ You can find also Smart Filter in the custom visuals marketplace (Smart Filter is the free version, Smart Filter Pro has additional features).

Келесі