Power BI

Back in February, I wrote a blog on how you can trigger a single table to refresh in your Power BI data model. This blog described how you can achieve this goal using a PowerShell script and the AS…

With the increased use of data to drive business decisions, your organization can't just stick its neck in the sand and ignore data privacy anymore.

We are excited to announce that we have partnered with Data Vizioner, a data intelligence platform for Power BI that helps people build reports.

Power BI dataflows is a nice capability of Power BI. It’s actually not a new Microsoft product. If you use Excel and Power BI long enough, there is a big chance that you’ve already used Power Query …

Shared via Flipboard

It is easy to add an animated GIF to your Power BI Reports. However, if you just add it as an image, it won’t animate. You’ll just get a static image. Animated GIFs can be useful in reports to explain new features to users, or on hidden developer pages showing how certain things were done. To add

Learn how you can use Power BI DAX functions to get the minimum start date and maximum end date of all children tasks.

data business intelligence bi machine learning mi professionals contractors azure Power bi analysis ETL ELT modeling automation training leadership

This article describes how to correctly use column references when manipulating tables assigned to DAX variables, avoiding syntax errors and making the code

While using multiple categories in a table/matrix, data analysts often prefer to rearrange, reorder or group specific rows or columns. Inforiver supports all these features this for table/matrix style reports in Power BI.

In the 2nd part of the series, learn what Synapse brings to a table for Power BI developers, and how you can leverage both tools to get indefinite number of use-cases!

Slicer and filter were around in Power BI for a long time now, and plenty of blog posts were created comparing them to each other. Because these features constantly get updated and there are considerations outside of just a single report, I thought to write a comprehensive guide that I can point to every time […]

When you build a date table in Power Query you might use the functions under Date to add year, month and day And this will give you three steps in your Query But we can do this a bit faster, and yo…

As we move into the last third of the year, the Power BI team have had a busy summer working on delivering exciting innovation for you, our community. We have a number of sessions during Ignite delivered by experts which gives you a great sense of the capabilities you can try, deploy or scale for your organization. As with everything we do, we’re grounded on the mission of empowering every individual, team and organization make better data driven decisions. Let’s take a look what sessions you can put into your backpack this Ignite.

Though you can build real-time reports with DirectQuery, push datasets offer a more scalable, economical, and effective solution especially when combined wi

This session will help you understand evaluation context, so the next time you create a DAX measure, the result will be consistent and expected.

Recent integrations between Azure Purview and Power BI enable greater data agility for organizations of all sizes

Something that got lost in all the excitement around Excel reports connected to Power BI datasets working in Excel Online is the fact that Excel reports connected to the Excel Data Model – ak…

In this article, we share an idea to reduce the friction in using Power BI, by extending the DAX language with new visual calculations. At SQLBI, we teach D

Scenario:  Usually, we can forecast values and return a line chart by using R visual in Power BI. But since it can only return image, how can we return the values as a table? And how can we use these values in the subsequent analysis?   Sample data:  The sample data is as follows and the complete d...

Reflection on how “You have to be technical” during informationals or interviews, especially with lack of context can lead to undesirable outcomes, including gatekeeping and more.

Push datasets are an efficient and inexpensive way to implement real-time updates in Power BI reports and dashboards. They can provide better performance an

Though you can build real-time reports with DirectQuery, push datasets offer a more scalable, economical, and effective solution especially when combined wi

In power bi is not easy to define arbitrary 2 level column headers in a matrix visual. In this article we try different approaches and a final solution

The quick measure calculates the Pearson correlation coefficient between two measures within the category.   NAME: Correlation coefficient   DESCRIPTION: Calculate the Pearson correlation coefficient between two measures within the category   PARAMETERS: Name: Category Tooltip: The category in which...

How to simplify DATA with an INNOVATIVE narrative? Here comes the story, with data. Creativity is one of the foundations of innovation and data is the basis of our Digital period. Learning to deal with both, through storytelling, means turning information into solutions, understood for a lot of P...

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

#powerbi #MSPowerBI

Warning : this documentation may mention some features under development which will appear in short term.

DAX generator is a component of Power BI Sidetools able to create complex DAX expressions within your model. Once you built or found the appropriate template,