Forum Discussion
creating measures take long time
Yes, again!
Whenever you create a measure, PowerBI reviews its dataset to see what could inflict the new measure.
Having an imported dataset of +1gb is not fun to work with.Is working with DirectQuery a possibility? This wil only load the data you actually use.
Yes, again!
Whenever you create a measure, PowerBI reviews its dataset to see what could inflict the new measure.
Having an imported dataset of +1gb is not fun to work with.
Is working with DirectQuery a possibility? This wil only load the data you actually use.
Thanks RobbeVL ,
Yes I can understand validation is needed, but I guess review is not all that happens. If you e.g. crates a calculated table that in one of the columns generates random numbers, you will see that each time you create a new measure (could be as simple as Measure=1), the values in the random column are re-calculated. I can't see why this is happening, and if this is part of the reason that it takes a long time to create new measures I guss it's something that Microsoft can do better
I agree and would add this is not really acceptable. I would question the idea that anything larger than 1 gb is large. I've already cut down my facts to only a few years with the pbix down to 800k (was 1.5 gb) and still adding a measure takes minutes each time. We do this same thing in SSAS and it's instantaneous. Why is PowerBI desktop so much slower than visual studio with SSAS? btw.....I'm running the same terminal server to do both SSAS and PBI desktop.
Nowadays Tabular Editor is the way to go here, but still...
I haven't used tabular editor other to unsuccessful attempt to use it to convert from SSAS to datasets. Will give that a try for development work.
In fear of preaching to the choir...So curious why Microsoft doesn't provide the tabular editor themselves? So much emphasis on this tool and yet so little support for enterprise types of development. What would make WAY to much sense is if they simply supported datasets in SSDT like SSAS. Then transitioning from SSAS to PowerBI datasets would be basically seemless rather than having to start over again in PowerBI. Come on Microsoft....its the same product behind the scenes...seems insanity they are making this so difficult.
