Power BI

Join Arun Ulagaratchagan on May 4th, 2021 at Microsoft Business Applications Summit!Join the Power BI team and be inspired by exciting new features, see amazing demos, learn about our roadmap, see …

Here are resources to help you learn how to use Paginated reports. You will need a premium capacity or Premium per user license. If you have any extra resources please reach out to me on Twitter …

For a while now, I have been wanting to have the capability in Power Query to select a query by name PROGRAMMATICALLY. Why? Building a SelectQuery Function would allow me to execute one of multiple “Transform” queries depending on a user selection on the Excel sheet. This will help me process log fil

Bring DML to Power BI with Power Automate – Delete Records An exciting addition to Power BI April release is Power Automate Visual. This adds a host of capabilities to Power BI directly without relying on Power Apps. Users can now activate PA flows directly at the click of a button from Power BI p...

A lot of us work with Power Query Editor in Power BI and are familiar with its different capabilities that it provides to a report developer. I was recently approached by one of my colleagues who has started learning Power BI, to check if there is a way to implement CONTAINS functionality on a TEXT ...

Power Apps offers you a variety of icons - and recently, there were nice additions announced and rolled out. But if we want to create even more appealing apps, it makes sense to extend our pretty …

How to edit Power Apps Source Code files of Canvas Apps. Unpack a .msapp file for source code file editing and repack it again for updating.

Two of my previous posts are related to creating an automated data dictionary - something I believe is essential to inform users about your model and to promote a more optimal use of your model. The …

Do you want to highlight your top or bottom values dynamically in Power BI? Patrick looks at a creative way to accomplish this using WHAT IF parameters. Download Sample

Announcing Charticulator visual preview. Previously to use Charticulator, a user would flip between the web app at charticulator.com and Power BI (PBI). Now, users can create a wide range of custom chart designs right within PBI using our brand-new Microsoft Charticulator custom visual.

Azure File Storage and Excel Online (Business) Connector upgrade

Learn about how you can set up dataflow automation using the Power Query Dataflows connector in Power Automate!

Learn how to trigger flows from any Power BI report using the new Power Automate visual for Power BI and the Power BI button clicked trigger.

Application Introduction: End to end employee hardware ordering solution. This solution simulates how a large organization might supply their employee’s hardware needs. This offering consis…

The purpose of this article is to provide Power BI developers with a deeper understanding of the dependencies when updating data sources in a Power BI dataset through XMLA endpoints. Most importantly, Power BI maintains security-related data source information such as credentials and privacy settings outside the dataset, whereas Azure Analysis Services and SQL Server Analysis Services maintain these settings in the data model.

The April Power Apps community call we are happy to announce Hardit Bhatia will be covering his ‘Make your Power Apps sessions persistent when switching Teams tabs!’. Then Matthew Devaney, Geetha …

It’s been a pretty awesome month for folk who want more visualisation opportunities in Power BI - we’ve seen the launch of PureViz Infographic, and last week Microsoft announced the Charticulator …

Hi Power BI Folks! Welcome to our 2nd post here at daxproservices.com.Today, I wanted to share some thoughts about how to keep the house clean when naming the transformation steps of your Power Query …

Today we’re excited to announce a vast new set of capabilities that provide enterprise grade application lifecycle management for the data sources used within canvas apps and cloud flows. Environment variables are now natively built into authoring experiences across canvas apps and flows as well as solution and solution import experiences. We’ve also added several new API’s to simplify working with environment variables in code and within automated ALM pipelines. 

Power Automate Desktop comes with new features in April 2021 release, including the image-based recorder, improved interaction with Java applications and an enhanced action copying mechanism.

For a while now I have been looking into how to set up some sort of CI/CD for Power BI. Unfortunately there is not much out there, except if you have the luxury of working with Power BI premium. As…

One of the most common questions coming from customers while using Power BI reports: ‘Can we export this to Excel?’. This to annoyance of most BI developers, as they spent a lot of time…

Over the years I have written a lot about Power BI/Power Query performance but it has always been in the context of loading data direct into datasets, not dataflows. A lot of cool things have been …

In this blog post I show how to create or update a measure in Power BI Desktop and then deploy to Power BI Premium Per User

Empower your end-users to go from insight to action. With the new Power Automate visual, end-users can run an automated flow all within a Power BI report. Furthermore, the executed flow can be data contextual, meaning that the Flow inputs can be dynamic based on the filters set by the end-user.

Welcome to the first Power BI feature summary of the Spring! In this update we have an exciting new preview for the Power Automate visual! Also, the ongoing previews (Small Multiples and DirectQuery for Power BI datasets and Azure Analysis Services) are getting some new features. Next to that, we are presenting huge improvements to the shapes in Power BI Desktop and we are introducing a new, easier, way to share reports. To top it off, enhancements to Sensitivity Labels provide for even better protection of your data. Of course, there is much more, so read on!

Shared via Flipboard

This article analyzes a classic modeling question: is it better to build a model as a regular star schema or as a single table in Power BI? The answer is cl