Using ConcatenateX in PowerBI to return multiple values.
In this blog post we’ll take a quick look at using ConcatenateX function to view a concatenated string of dates where the max daily sales occurred for a given […] Continue Reading…
Regular Expression to get tables from SQL query
If you’ve not come across regular expressions (RegEx) before then you’re missing out, they’re an incredibly powerful tool for matching, extracting or validating patterns of text.
I had a use […] Continue Reading…
Sorting a Power BI table by multiple columns
A common request that is raised by clients is how to sort a table in Power BI by multiple columns, in the same way you can in Excel.For a […] Continue Reading…
Power BI Databricks Spark connection error
When querying data from Azure Databricks (spark) into Power BI you may encounter an error: “ODBC:ERROR [HY000] [Microsoft][Hardy] (100) The host and port specified for the connection do not […] Continue Reading…
Cube deployment error: Cannot resolve all paths while de-serializing Database
I recently came across the following error while deploying a tabular cube using the Analysis Services Deployment Wizard:
My updates for this deployment included removing a table from the cube. […] Continue Reading…
Azure Data Factory (ADF) Parent Activities don’t trigger ON ERROR OUTPUT when Child Activities Error… What happens?
So that title is a big question that a client of ours came across that required some additional investigation… What does happen and how do we get around it? […] Continue Reading…
Creating calendar tables with DAX using Power BI
By Nick Edwards
In this blog post we’ll take a quick look at creating a self-generating calendar table using DAX.
Dates are important if we want to perform time intelligence reporting […] Continue Reading…
Creating a Python function to calculate Pi
Pi is 3.14159 to 5 decimal places.To work out Pi, we will be using Leibniz’s formula:X = 4 – 4/3 + 4/5 – 4/7 + 4/9 – …This series […] Continue Reading…
SQL LAST_VALUE() wrong results
You may have come across the following scenario when using the LAST_VALUE() function.
You want to find the first or last value loaded in a result set, therefore you use […] Continue Reading…
System OutOfMemoryException when deploying SSIS .ispac
If you’ve tried deploying a .ispac using the Integration Services Deployment Wizard, you may have come across the following error:
By default SQL Server uses the 32-bit version of the […] Continue Reading…
The Frog Blog
Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning and more.
This is a collection of thoughts, ramblings and ideas that we think would be useful to share.
Authors:
| Alex Whittles (MVP) |  |
| Reiss McSporran |  |
| Jeet Kainth |  |
| Jon Fletcher |  |
| Nick Edwards |  |
| Joe Billingham |  |
