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