Power BI

This month, we are continuing our work on the ongoing previews of DirectQuery for PowerBI datasets and Azure Analysis Services, Small Multiples, and the Model View UI. Also, we are making it easier to specify filters in the DAX CALCULATE function. On the Service side, when you click on a dataset in the workspace list view you will be taken to our new dataset details page, which includes information about when the report was last refreshed as well as actions such as creating a new report. Of course, there is much more, so read on!

The Microsoft Business Applications Launch Event is almost here. Join us on April 6, 2021, from 9–10:30 AM Pacific Time (UTC -7) to discover how new innovations coming to the 2021 wave 1 release will give you the tools you need to transform your business

We are excited to announce General Availability (GA) of support for external tools within the Power BI Desktop authoring experience so that you can leverage a wide range of additional semantic modeling features, DAX query/expression optimization and authoring utilities, and application lifecycle management (ALM) capabilities in Power BI Desktop to boost your productivity as a world-class Power BI solution creator.

I previously wrote a blog post explaining how to rename all columns in a table in one go with Power Query. One of my visitors raised a question in the comments about the possibility to rename all columns from all tables in one go. Interestingly enough, one of my customers had a similar requirement. So … Continue reading Quick Tips: Renaming All Tables’ Columns in One Go in Power Query

Join me tomorrow, Thurs March 18 at 10am PDT / 1pm EDT / 5pm UTC for a webinar hosted by the Power BI team: Improving Trustworthiness of Power BI Content...

[vc_row][vc_column width="1/1"][vc_single_image media="88081" media_width_percent="100"][vc_column_text]Download the following Power BI file as a template to start validating email addresses directly in Power […]

We are proud to announce great news for DAX Guide! Starting today, every DAX function has its own dedicated video. Moreover, we added new examples that you

Welcome to my first blog post! I've promised to give back to the SQL and Power BI community for almost six years now and have never been quite ready. The community has done so much

Reading Time: 4 minutesFrom a creative standpoint, it’s disheartening if you’re often trying to get users past a Table and Export mentality with Power BI. What otherwise could be a strong BI tool …

Just an end user of Power BI? Consuming reports and not authoring at all? Adam walks through how to navigate and use Power BI reports. Jump in and get familiar with reports in Power BI! Reports in Power BI https://docs.microsoft.com/power-bi/consumer/end-user-reports View a report in the Power BI service for business users https://docs.microsoft.com/power-bi/consumer/end-user-report-open

Launching the anticipated autoscale add-on preview for Premium gen2 capacity

This article explains the most common causes of the error, “A circular dependency was detected” in Power BI and Analysis Services. A circular dependency

Maybe you want your Power BI report users to get be notified of some changes that occurred. And, you want that displayed within the report. Patrick has a way you can do just that!

Reading Time: 4 minutes From a creative standpoint, it’s disheartening if you’re often trying to get users past a Table and Export mentality with Power BI. What otherwise could be a strong BI tool ends up simply being used as middleware for Excel. Alongside...

[vc_row][vc_column width="1/1"][vc_single_image media="88067" media_width_percent="100"][vc_column_text]In this Power BI tutorial, you'll learn how to lock down your data model using Object-Level Security […]

I have already done a video/post on how to implement a static drop down navigation, so in this tutorial I will cover how to implement a dropdown navigation where options are dynamically populated b…

We are excited to announce the public preview of VNet connectivity for Power BI datasets.

In this blog post I show how to use Object Level Security in Power BI to limit access to non-financial data.

The Microsoft Power BI team’s mission is to help our customers drive a data culture where everyone can make better decisions with data. Power BI empowers every business user and business analyst to get amazing insights with AI infused experiences. With Power BI Premium, we enable business analysts to not only analyze and visualize their data, but to also build an end-to-end data platform through drag and drop experiences.

I sometimes get asked from customers if they should use a star schema or should they use one large single table/flatfile for their dataset in Power BI. The answer is almost always star schema, and …

Power BI offers an add-in to work with 3rd party external tools like Tabular Editor , DAX Studio and ALM toolkit . The fact that you can use a tool of your own preference is already really cool! But did you know that you can build external tools yourself pretty easily? Even as a non-develope

The blog post demonstratesstore the Power BI Audit Logs using Azure Function Apps and Azure Blog Storage to store the files.