Change the Compatibility Level of a Power BI report
November 3rd, 2021 in Blog, UncategorizedA number of new features in Power BI are limited to newer Power BI datasets, which Microsoft track through the use of Compatibility Levels. 1500+ for SQL Server 2019 compatibility 1400+ for SQL Server 2017 compatibility 1200+ for SQL Server 2016 compatibility If you want to, for example, connect to the xmla endpoint of the dataset from SQL Server Management Studio, then you need level 1500 or greater. If it’s lower you’ll get the…
» Read moreSpeaking at Data Platform Summit
August 20th, 2020 in Blog, Community, Machine Learning, Power BII’m delighted to have been selected to speak at the Data Platform Summit (DPS), a virtual conference from 2nd to 4th December 2020, with Data, Analytics and Machine Learning content around the clock for a global audience. I’ll be presenting a session on “Machine Learning in Power BI”, exploring various methods of accessing Machine Learning functionality within the Power BI world, including text analytics, prediction…
» Read moreRegular Expression to get tables from SQL query
June 3rd, 2020 in .Net, BlogIf 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 case this week where I needed to take a SQL query, and quickly identify every table or view that was used in the query. RegEx to the rescue! (?<=((FROM[ \n\r]+)|(JOIN[ \n\r]+)|(APPLY[…
» Read morePower BI Databricks Spark connection error
May 19th, 2020 in Big Data, Blog, Cloud, Power BI, SparkWhen 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 seem to belong to a Spark server. Please check your configuration.“ This is usually caused by trying to connect to a ‘Standard’ Databricks instance, but Power BI (and ODBC in general) can only connect to Databricks using a…
» Read moreCapturing Insert and Update Counts from Merge
November 9th, 2019 in Blog, UncategorizedThis post shows hows how you can capture and store the number of records inserted, updated or deleted from a T-SQL Merge statement. This is in response to a question on an earlier post about using Merge to load SCDs in a Data Warehouse. You can achieve this by using the OUTPUT clause of a merge statement, including the $Action column that OUTPUT returns. The basic syntax is: INSERT INTO XXXX SELECT [Action] FROM ( MERGE XXXX AS Target USING XXXX…
» Read morePower BI Sentinel
March 25th, 2019 in Blog, UncategorizedWe all know and love Power BI, because of it’s power and ease of use, there’s a good reason why it’s number 1 in the Gartner Quadrant. But how to we avoid ‘Power BI Hell’, the new version of our old nemesis ‘Excel Hell’? How do we keep track of which data sources are being used by which datasets and reports? How to we perform an impact assessment of updating/changing a dataset? What happens if someone…
» Read moreSSAS Tabular Deployment Wizard fails Newtonsoft.Json error
July 25th, 2018 in Analysis Services, Azure, BlogThe Scenario Deploying an Analysis Services Tabular model to SSAS Azure using the Analysis Services Deployment Wizard. Both Visual Studio 2017 & SQL Server 2017 installed on the client. Try and click on the ellipses to change the data source connection string or impersonation information results in a Newtonsoft.json error: “Could not load file or assembly ‘Newtonsoft.Json, Version 6.0.0.0, Culture=neutral, ……”…
» Read moreMore Frogs join the FrogPlex!
July 5th, 2018 in NewsJune has been a very busy month for us at the FrogPlex – Firstly Lukasz joined the team, to help work on our clients’ business intelligence projects, and also to expand our Machine Learning and Advanced Analytics capability. In his first month he’s already been tackling projects in SSIS, Data Lake Analytics, building customer churn models in R, as well as providing support to our existing customers. A very warm welcome to the…
» Read moreLookups and If Conditions in Azure Data Factory v2 (ADFv2)
June 5th, 2018 in Azure, Blog, Data Factory, SSISAzure Data Factory v2 (ADFv2) has some significant improvements over v1, and we now consider ADF as a viable platform for most of our cloud based projects. But things aren’t always as straightforward as they could be. I’m sure this will improve over time, but don’t let that stop you from getting started now. This post provides a walk through of using the ‘Lookup’ and ‘If Condition’ activities to do some…
» Read moreSQLBits 2017 – Several Shades of Purple
March 22nd, 2017 in NewsThis year Purple Frog Systems are getting involved in SQLBits more than ever before! With Europe’s biggest Microsoft data platform conference being hosted in our home town of Telford we had to set the frogs free and add our special shade of amphibious purple to the 2017 event. We’re part of the event organising committee. We’re official event sponsors. We’re official conference helpers. We’re speaking in sessions. We’re recruiting.…
» Read more
Call today 0845 643 6463
