M Mysteries: SQL - M (SqlExpression.ToExpression) | Ben Gribaudo

Power BI
On-premises data gateway July 2021 update is now available
On-premises data gateway (standard and personal mode) release for July 2021
Help us shape the future of Power BI – Exploring the idea of Integrating Power BI with Microsoft Forms
Back in May 2021, we announced the integration of the new Power BI quick create experience within SharePoint, which enabled the SharePoint users to easily generate awesome Power BI reports by just one click. Currently, we are exploring other applications where we could potentially integrate a similar experience and one of the application that we are exploring is MS Forms. We have created a survey to compile feedback from our customers on a potential integration with Microsoft Forms. If your organization uses Microsoft Forms and/or Microsoft Power BI, we would encourage you to make your voices heard by completing this ~5 mins survey.
pnp/powerapps-samples
Contains curated community Microsoft Power App samples - pnp/powerapps-samples

pnp/powerapps-samples
Contains curated community Microsoft Power App samples - pnp/powerapps-samples

The Power of Using Calculation Groups with Inactive Relationships (Part 1)
Learn how to leverage the power of calculation groups to activate inactive relationships without creating multiple measures!
Filter Based on Categorical Measures in Power BI | BI Elite
[vc_row][vc_column width="1/1"][vc_single_image media="88181" media_width_percent="100"][vc_column_text]In this Power BI tutorial, you'll learn how to filter based on a measure value! In this […]
PowerApps Replace Function with examples - SPGuides
In this PowerApps tutorial, We will discuss what is PowerApps Replace function, What is Powerapps Replace string, and it’s all syntaxes.Also, by taking some simple scenarios, we will cover these below …

Power BI Adoption Framework.docx
Filter One Slicer Based on Another Slicer in Power BI - Excelerator BI
This is a follow up article from my last blog post where I demonstrated how easy it is to use two slicers to compare any two items. In the demo in my article, I specifically showed how you could compare any 2 years of choice, but the principle applies to [...]Read More »
DAX Studio v2.16.2 Released – Random Procrastination
All in One: Script to Create Calendar Table or Date Dimension using DAX in Power BI
Learn how easy you can create a fully-fledged calendar table in Power BI using a DAX script just by copy and paste into your file.
Microsoft Power BI Write Back - Power Platform Community
Using the capability of Power Apps to write to the data source and that of Power BI to embed Power Apps in it’s report or Dashboards we can add write back functionalities to our Power BI Reports and Dashboards. This will help the users of the Power BI Report or Dashboards to directly make changes in...

Build large-scale data copy pipelines with metadata-driven approach in copy data tool - Azure Data Factory
Provides information about the metadata-driven approach in ADF copy data tool

Get control of data loads in Azure Synapse
Get control of your Data loads in Azure Synapse Analytics by using Metadata-driven control tables to optimize the data extraction

Power BI Report Development 101 - Part 1
Are you new to Power BI? Maybe you've been using it for some time but you're still not sure how the end to end process works? This flowchart was made for the users that are still in the beginning of their Power BI journey! In my diagram, I divided the report development process into four main steps: 1) Analyse data and build your data model 2) Report Design 3) Prepare to share your report 4) Share your report In this post, I'm going to guide you through each one of the steps, and share some usef
My views on Power BI core skills
I'm going to start this post by saying that it will be a bit different from the posts I've written before. Today, I will be sharing with you my ideas around core Power BI skills, and how I see them changing in the future. I'm very interested in learning about your experiences and your opinions around this topic as well, so please share your thoughts on the comments below. All points of view are valuable! If you work with Power BI already, you probably agree with me when I say that over the years
Power Platform tenant-level analytics explored - Forward Forever
The new telemetry data available in Power Platform Admin Center improves visibility into your tenant's low-code solutions. How does it compare with CoE Starter Kit?

Power BI admin - Pay attention to these upcoming updates! - Forward Forever
Some of the biggest changes in Power BI are rolling out this year. Premium Gen2 being the biggest of them. If you are a Power BI admin, check this list out!
Power Query M Primer (Part 21): Identifier Scope & Sections | Ben Gribaudo
Power BI - Report performance best practices
Why is my report slow? What could I do to prevent my report from becoming slow? I hear these questions a lot, and the truth is, there is no silver bullet. If you've built your report already and you noticed the performance is not as good as you thought it would be, there are multiple reasons why this can be happening. In this case, it's important that you understand the root cause of the problem, as it's the only way to quickly fix it. In this blog post, we are going to focus on the second quest
What can you do with Power BI and perspectives? | flip-it.de :: SQL, BI and more
24 services you get with a Microsoft 365 subscription in 2021
Find out what you get with a Microsoft 365 subscription! This guide has been written to explain to end-users who would like to know "what Microsoft 365" is.

Top 10 Power Apps Tips Of 2020 - Matthew Devaney
Here's my list of the top 10 Power Apps tips of 2020 featuring a few friends who I have learned things from.

Referential Integrity violations in a Data model, what are those? - Self-Service Business Intelligence
What is referential integrity and why you need to make sure you have it. Learn how you can find and solve issues with it.
Introducing Seven New Connectors
We are thrilled to end the month of June with five new connectors. These connectors provide solutions for sending Adaptative Cards, using CPQ software, and improving IT, Finance, and HR processes. To know more, check them out in this post.

Create Power Apps Collections Over 2000 Rows With These 4 Tricks
Do you want to create Power Apps collections over 2,000 rows? I will show you the special techniques needed to go past the delegation limit.

Chris Webb's BI Blog: Power BI Dataset Refresh, Column Encoding And The First Partition Chris Webb's BI Blog
If you’ve been following some of my recent posts about improving Power BI refresh performance by partitioning tables you will have seen a lot of screenshots that look like the one below: It&#…
Calculating Age in Power BI – Data Savvy
In week 26 of Workout Wednesday for Power BI, I asked people to calculate the age of Nobel laureates at the time they received the award. I provided some logic, but I didn’t prescribe how to …
Time Intelligence Dynamic Legend in Line Charts
dynamic labels and calculation group precedence seem unrelated, but need to go hand by hand. This article shows a technic to avoid the dangers.