And populating the model is an unnecessary extra step that wastes time and resources. If you want to use Import mode I would avoid building a Tabular model if you can, they are not a good source for reading detailed information. And populating the model is an unnecessary extra step that wastes time and wondering if I've to create measures and KPIs again in Power BI Data Model then what is the use of Tabular in between my data source and Power BI? just to join the Dim and Fact tables? You can add report level measures to a model in live connection mode, but you can't add new tables and columns. If you already have a Tabular model or you want an official model that has been tested and proven that you don't want anyone altering then using a Live Connection is the way to go. The script of the Advanced Editor looks as below. If I go with Live connection, report developers won't be able to add more sources if require or add more measures and calculated fields. When I choose 3 tables from SSAS Tabular model using 'import connection' I will get only 1 table in PBI Desktop model with all columns joined. It is a waste of time and resources to build a Tabular model in between your data source and Power BI if you just going to import the data into Power BI is the most efficient and reliable connection type with Tabular model? Import or Live Connection? If you want to use import mode in Power BI there is no point using a Tabular model. Wondering if I've to create measures and KPIs again in Power BI Data Model then what is the use of Tabular in between my data source and Power BI? just to join the Dim and Fact tables?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |