SSAS Tabular Deployment Wizard fails Newtonsoft.Json error
The 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 […] Continue Reading…
Lookups and If Conditions in Azure Data Factory v2 (ADFv2)
Azure 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 […] Continue Reading…
Sampling data in Data Lake U-SQL for Power BI
Being able to hook Power BI directly into Azure Data Lake Storage (ADLS) is a very powerful tool (and it will be even more so when you can link […] Continue Reading…
Showing December to December to see opening values for a year in SSAS/MDX
I came across an interesting MDX challenge this week; within a cube’s Date dimension, how to show December twice, once where it should be and again as the opening […] Continue Reading…
SQL Server 2016 Licensing Changes, SP1, v.Next CTP1, etc.
By now you’ve probably heard the exciting news announced at today’s Microsoft Connect conference; SQL Server licensing is changing, significantly, from SQL 2016 SP1.
The functionality of SQL Server Standard, […] Continue Reading…
What is U-SQL?
By now you may have heard about U-SQL, the new kid on the query language block. But what is U-SQL? Where is it? What’s it for?
I was lucky enough […] Continue Reading…
PASS Summit and MVP Summit 2015
I’m currently sitting in Seattle-Tacoma airport waiting for BA048 to take me home, and coming to terms with what an amazing couple of weeks I’ve been fortunate to have.
The […] Continue Reading…
MDX Compare or Rank Similar Members
Or should this be called: “Recreating DAX’s EARLIER function in MDX” – either way, a useful technique that solves a problem…
MDX makes it very easy for us to compare […] Continue Reading…
Excel crashes when enabling macros
I’ve had a problem with Excel 2013 crashing a number of times when opening/editing spreadsheets with macros. When I click ‘Enable Content’ to enable macros, the Excel window fades […] Continue Reading…
First thoughts on DataZen
Following the recent announcement of Microsoft acquiring DataZen, I’ve been having a play around to see what it can and can’t do. Here’s a very brief summary so far:
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 |  |
| Liam McGrath |  |
