Lets Do Power BI

Yes, its possible and here is how you can do it. When you work with large data models , one thing that bothers us the most is the performance of the reports. As a Power BI Architect, I have worked on a variety of data models — from small ones with just hundreds of rows to larger ones with up to billions of rows. And guess what, the most common ask from any client is that they want a dashboard with optimized performance. Though there are multiple ways to optimize the performance of a data model, the primary thing is to reduce its size. Power BI models in Import mode are loaded with data that is compressed and optimized and then stored to disk by the VertiPaq storage engine. When source data is loaded into memory, it’s possible to see up to 10x compression. Despite VertiPaq storage engine efficiency, it’s important that you take steps to minimize the data that is loaded into your models. This can be done in really simple steps. Here, I list down 5 very simple methods to do so. I’ll be...

I have started using the new feature and here is how it can help Power BI Developers AI-Image generated by Author Microsoft has finally brought something that Power BI developers have been demanding for a very long time. TMDL View is here, available from the January Power BI update. For the unversed, TMDL is Tabular Model Definition Language , which is the script behind any Tabular model. Though it’s still in preview and should not be tested on production data, developers can try it out and provide their feedback. Although Microsoft had already provided the feature to save Power BI files as project files (.pbip file type) and store the semantic model in TMDL format last year, to actually leverage the files, one needed to rely on external tools like Tabular Editor. But now, with this update, TMDL view is available to developers in the Power BI Desktop itself, making it easier to manage the semantic model objects. And obviously, you need to enable this preview feature from Option...