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…
Using Azure Analysis Services to connect via an ODBC Source (Redshift)
I am busy working with a customer and had a challenge when using Azure Analysis Services to connect to Amazon Redshift via an ODBC connection. The first issue that I encountered was the following error: OLE DB or ODBC error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application; AWS PROD. This lead me…
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…