Power BI Desktop – How did I connect to Analysis Services using my Power BI Desktop Application when I was outside of the Analysis Services Domain?
I was working with a customer where I was working on my own laptop. My laptop is not part of their domain. I did have an account in their domain and when I tried to connect using Power BI Desktop, I got the following error when trying to connect as shown below. This is not the greatest error message. Fortunately,…
Using Version Control with Power BI Desktop Files, check in, check out, view or revert to previous versions | Part 2
In the second part of my blog post I am going to detail how to use the version control with Power BI Desktop files. This will include adding files, checking files in and out, viewing previous versions and reverting to previous versions. If this is the first time you are reading this blog post, I would highly suggest reading Setting…
Does the New Look #PowerBI Service use more or less report page screen real estate?
I have seen quite a lot of chatter with regards to the Power BI Service new look and feel, which I personally really like. People were saying that whilst they like the look and feel, it appears to be taking up more real-estate screen space. As well as others preferring the tabs along the bottom like Excel does. I took…
Setting up Version Control for my Power BI Desktop Files (PBIX) with no additional Cost * | Part 1
I very often hear people asking if it is possible to use Source Control or Version Control with Power BI (PBIX) files, and whilst I was working with a customer this week, I found a way to enable source control. Wait, wait before you go running off and reading the rest of the blog post, let me first say that…
Enabling External Power BI Users to easily view App Workspaces or Apps shared with them
Having the capability to connect external people (B2B) into your data within Power BI is a great feature and a huge advantage when comparing to other customers in my opinion. In this blog post I want to demonstrate how to easily allow external users to always find the data that they have access to in other organizations. I have been…
DAX – How to get a line break in a DAX measure for Labels or Titles in a Power BI report?
Once again, I really enjoy working with Power BI and in the data and analytics space. I was at a customer and they were drilling through between pages, and I wanted to put in what the filter selections were when they drilled through to the new page. This would allow them to easily see what had been on the previous…
How to connect to your Power BI Premium Datasets using Excel (with the XMLA End Points)
I have had seen a few questions in the Power BI Community, as well as from other people asking if it is possible to connect directly from Excel to a Power BI Premium dataset from Excel. Without having to log into the Power BI Service or download any .ODC files. I am going to show you how to do this…
How to setup and get a Certified Dataset in #PowerBI
There is the new functionality in the Power BI Service where you can now get your data certified. In this blog post I am going to explain all the steps involved to getting a dataset certified. Some of the steps below will require a Power BI Admin to complete certain steps. As described in the documentation not all datasets will…
Embedding Word Documents into new App Experience within #PowerBI
I was recently fortunate enough to go to the Microsoft Business Applications Summit where I had a great experience. One of the things that they did talk to, was creating links within the New App Experience which could link to other web pages or documents. This is really an awesome feature, and it enables users to stay within the App…
Review of new features & Announcements for #PowerBI – From the Microsoft Business Applications Summit
I was once again very fortunate to make it across to the Microsoft Business Applications Summit in Atlanta. I had 3 sessions which I presented at, and they went well. It was great to meet new people (some of whom I had only read their blog posts or viewed their videos) and reconnected with existing people. As I did last…