Power BI

It’s here! Patrick does a reaction video when using Tabular Editor 3 for the first time with Power BI. To say he’s excited is an understatement. Watch him take the wrapping off of Tabular Editor. Tabular Editor: https://tabulareditor.com/

Time to read: 4 minutes Calculation groups is a powerful feature in Power BI. However, using them adds some complexity and brings some limitations to Power BI’s native functionality. Or... Read more »

500 million+ members | Manage your professional identity. Build and engage with your professional network. Access knowledge, insights and opportunities.

Contribute to GreyskullAnalytics/Dynamic-Measures development by creating an account on GitHub.

C# scripts are great to automate tasks which are repetitive but have some customization for each model

Learn how to use the RELATEDTABLE function in DAX and Power BI to get a subset of rows from a related table

The third part of the blog series covers loading data into AAS or PPU and how this happens and works.

Paradigm BI Posts - Paradigm BI and Active Business Intelligence Updates - Planner is a good, cheap and effective planning tool, but it is weak in its reporting offering. Plan

Power BI Calculation groups can solve data modeling challenges in a clean easy way, like a table filtering two dimension tables without model relationships

In this blog post, I'm discussing whether you should use Power Query in dataflows or in datasets, comparing the two options.

Evaluation context is the most important concept to understand in DAX . This context is used when evaluating expressions to get to the result.

Learn how to extract parts of a text column's value in Power BI using some very simple-to-use transformations in Power Query.

On-premises data gateway (standard and personal mode) release for June 2021

We’re happy to announce new developer samples that will show you how to add data source, update data source, and encrypt credentials. In the new samples you’ll find an end-to-end flow of all the required Power BI REST APIs. The samples are available in .NET Core, Java, and Python. You can find the new samples … <p class="link-more"><a href="https://powerbi.microsoft.com/en-us/blog/new-developer-samples-for-update-data-sources-and-encrypt-credentials/" class="more-link">Continue reading<span class="screen-reader-text"> “New developer samples for update data sources and encrypt credentials”</span></a></p>

I had the pleasure speaking with Reza Rad on his YouTube live session. Watch out the recording and learn how to harness Power Query and dataflows as a low-code data quality solution and use my Dataflow Snapshots Analysis app.

Join us for an in depth discussion with Seth Bauer as we explore ways to identify , build , and represent your Power BI Skills . There are so many different areas within Power BI that require different skillsets. Do you know what those are? Do you know how to raise your professional bar a

If you have rows with blank values, you can use Remove Blank Rows or Remove empty to filter them out. learn about their differences here.

Tabular Editor is a Power BI Tabular Modelling productivity tool developed by Daniel Otykier. I blogged about Version 2 of the Tabular Editor in this article here. The 3rd edition of Tabular Editor has just been released, and it is a major upgrade from version 2. TE 3 is not [...]

Export your Power BI desktop data into Excel with only one click. Then you can setup pivot tables, add theme & graphics, macros and do whatever you want.

We are happy to announce that Office Scripts in Excel for the web is now generally available for all eligible users!   What is Office Scripts? Office Scripts is an automation feature-set in Excel for the web that allows users with all levels of programming experience to automate their repetitive wo...

If you follow my blog posts, you know already that I'm a huge fan of the integrations of Power BI with the Power Platform, specially Power Apps and Power Automate. I truly believe that these integrations can take your reporting solutions to the next level, and if you are not into these topics already, now is the time to learn a little bit more about it. In this blog post, I'm going to talk about the integration of Power BI + Power Automate. During the last few months, I really struggled to find

Last week I showed how the new MaxEvaluationWorkingSetInMB registry setting could increase the performance of memory-hungry Power Query queries in Power BI Desktop. In this post I’ll show how…

Power BI is making it simple to view and analyze your personal Microsoft Teams activity with a new preview feature to ‘Analyze your Teams data’.

Learn how to export the Power BI audit log with no limitation and any size. No scripting or coding is needed.

Learn what happens when you open a PBIX file with Power BI Desktop and why you might wait many seconds with large files. Do you need more RAM or a faster CP

We’re excited to introduce new developer samples for embedding Power BI analytics in Salesforce. You can embed Power BI report, dashboards and more in Salesforce for your organization or for your customers. By embedding Power BI in Salesforce, your users will have access to Power BI interactive data visualizations that can be connected to all … <p class="link-more"><a href="https://powerbi.microsoft.com/en-us/blog/embed-power-bi-in-salesforce/" class="more-link">Continue reading<span class="screen-reader-text"> “Embed Power BI in Salesforce”</span></a></p>

Increase the performance of Power Query transformations in Power BI Desktop by setting the MaxEvaluationWorkingSetInMB registry key

Tabular Editor is a Power BI Tabular Modelling productivity tool developed by Daniel Otykier. I blogged about Version 2 of the Tabular Editor in this article here. The 3rd edition of Tabular Editor has just been released, and it is a major upgrade from version 2. TE 3 is not [...]Read More »