Blog

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…

WordPress Theme built by Shufflehound. Copyright @FourMoo 2021 | ABN 80 382 360 382