Power BI

In this article I explain two methods for exporting Power BI data to SQL Server. Exporting Power BI data with R and Exporting Power BI data with SSIS.

This is the second blog post in Power BI Row Level Security (RLS) series (Part 1 is here). Implementing RLS in Power BI is a fascinating topic. You will usually find multiple ways to implement it. As the requirements become more complicated, you will no longer be able to rely on dedicated AD groups, and …

Name: New customers Description: Calculate a measure filtering only the new customers in the selected period  Parameters: Name: Base value Tooltip: The value you want to calculate Type: Numerical field / measure   Name:FactTable Tooltip: The table containing the data used in Base value Type: Table  ...

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...

This measure calculates a rolling average. It takes a set number of periods before and after the current filter context and does an average over those values.    Name: Rolling average Description: Calculate the average of the value for a set number of periods before and after the filtered date  Para...

Below I am going to explain some of the caveats that you need to be aware of when implementing Dynamic Row Level Security (RLS) in Power BI. Without this I could not get Dynamic RLS security working for me and my data.   I found that there are a few things that are currently not mentioned anywhere...

Break-Even Analysis are easily solved when the cost structure is linear. This approach shows a solution for non-linear costs using goal-seek algo in PowerBI

In this blog post below I am going to show you how I created my own Custom Usage Metrics Report. NOTE: This has been done using my Report Metrics and not the Dashboard Metrics. NOTE II: I am going …

Thursday found me in Manchester, UK with the Power BI user group to discuss Cortana integration with Power BI and the Cortana Intelligence Suite. The group can be found here if you want to attend any

In today’s post, we will go over Tableau’s last four claims against Power BI (as was published by Tableau here), and we will demystify them. If you missed the last episode, go here, to learn the first 4 Ways Power BI Falls Short – Or Not. If you are an avid Tableau user, and are …

I installed the on premise data gateway and managed to get the connection running. When I enter "manage gateways"  on app.power.com it tells me   "Online: You are good to go". I also added data sources, (local excel files) which are on the same server where the gateway is installed and it tells me "...

I have installed the on premises gateway and adding sql datasources works fine. When i want to connect to an Excel file (stored on a network share), i get an error: "Can't connect to mashup datasource". In the error details the following error is provided: "path must be a valid absolute path" Howeve...

I had a requirement to connect and refresh their files stored in SharePoint On-Premise using the On-Premise Gateway. And are the steps that you can follow in order to connect to files stored within…

Hello!   I have a report connected to a spreadsheet in Sharepoint, as Web data source.   Everything is ok, but when I try to add a new data source to On-Premises Data Gateway, I get an error of "invalid connection credentials".    - I'm already using On-Premises Data Gateway with success for other d...

So far in this series, I have shown how changing the data privacy settings for a data source can affect the performance of queries and even prevent them from executing completely. What I haven’t me…

The Power BI mobile experience continues to evolve. In addition to much loved “just works” capabilities – dashboards and reports that just work on mobile – Power BI is providing more ways to create experiences optimized for devices of all sizes. For example, dashboards and reports optimized for phones allow even more control over the small-screen experience. Delivering a rich visualization on a large screen and then preserving that richness in a small screen can be a challenge. To address this challenge, we’ve created responsive visualizations.

This month’s Power BI Desktop update includes the general availability release of the new table and matrix visuals, an integrated experience with the custom visuals store, two community submitted quick measures, and more!

Last month we celebrated the Microsoft Data Insights Summit with a Data Analytics Challenge, and as usual we were highly impressed with all the submissions! Take a look at the videos and insights uncovered by the three winners.

In this video, Patrick shows how you can use Microsoft Flow, combined with Power BI, to monitor data and alert you when something is available. This takes advantage of a streaming dataset and using the schedule recurrence in Microsoft Flow to trigger an action as Patrick wasn’t using anything else to trigger it. You have […]

I'm trying to replace an old excel report with a better version using Power BI, but I am having trouble creating a measure that will replicate the results of the old report.    I have two time dimensions to my data - the CPS or Snapshot Date (i.e. when we received the data) and the Pack or Execution...

Good day,    Similar to my earlier post about generational bands. I want to create a retirement date calculation based on certain age bands as a calculated column. I know how to do this in excel, but not in the DAX formulation.    For example, if you were born 1937-1942 your retirement age is 65. So...

There are new HTML 5 enabled custom visualization for making interactive R visualizations in Power BI Desktop. Read the documentation and find the download links here . Because of the dependency on R packages that are loaded with the R library command.

In today’s post, we will continue to review the claims against Power BI (as was published by Tableau here), and demystify three more claims. Background This is the second part of a new series for Tableau pros, or BI teams, who consider extending their BI portfolio, and start their Power BI journey. Read part 1 …