Hiding the Filter Pane on opening a report or in Full screen mode in Power BI
I was answering a question on the Power BI Community where a user was having a challenge when opening a report in Full screen mode and it kept on expanding the filter pane. This report was only going to be run in full screen. Below are the steps on how I solved the solution. I solved it by doing the…
Creating a Time Dimension using the Power Query Editor in Power BI Desktop
Below is the syntax to create a Time Dimension Table in Power Query I had a requirement where I needed to create a Time Dimension for a customer. Most of the time I only need the date. Upon searching I could not find a resource where they had created the time dimension only using Power Query. Reference: https://docs.microsoft.com/en-us/powerquery-m/list-times What I…
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…
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…