Wise Owl Blogs - Home (page 1 of 19)

Showing blogs 1-20 (out of 368)

A way to get 32-bit and 64-bit drivers to co-exist on the same computer

Posted by Andy Brown on 21 September 2018

A (very) short blog containing a link to an article showing how you can import data from Access using SSAS or SSIS on a 64-bit computer

Tags:   SSIS | General SSIS

A run-through the new features in the August update of Power BI Desktop

Posted by Andy Brown on 14 August 2018

This is a bigger update than most, largely because it includes two major new features emerging from preview (report themes and desktop Q&A), but it's the export to PDF feature which really catches the eye.

Tags:   Power BI | Updates

A DAX formatter to tidy up your code

Posted by Sam Lowrie on 30 July 2018

Use this handy web based formatter to turn shameful code into neat DAX!

Tags:   Power BI | Measures / DAX

Debugging (sort of) in DAX

Posted by Sam Lowrie on 30 July 2018

Learn to use DAX variables, and understand how they can be used to break up code. Not true debugging, but better than nothing!

Tags:   Power BI | Measures / DAX

A summary of the new features in the July 2018 update to Power BI Desktop

Posted by Andy Brown on 25 July 2018

This month sees features allowing you to change the appearance of the icons at the top right of each visual, and also to change the appearance of the wallpaper surrounding a report, but otherwise all of the enhancements are fairly minor.

Tags:   Power BI | Updates

Five methods for creating partitions of SSAS Tabular tables programmatically

Posted by Andy Brown on 23 July 2018

Need to generate a partition for a fact table for each year, product or region? This blog gives five approaches, so that you can choose which method is for you.

Using partitions/processing to load a large fact table into a tabular data model

Posted by Andy Brown on 23 July 2018

This blog shows how you can load the empty structure of a large fact table into an Analysis Services tabular data model, then use partitions to bring in the data bit by bit.

How to show current drilldown filters in Power BI Desktop

Posted by Sam Lowrie on 20 July 2018

Some technique to remind users what levels they chose while using drilldown.

Stop automatic grouping in Power BI Desktop

Posted by Sam Lowrie on 20 July 2018

Read this blog to understand the risk of Power BI's automatic grouping of data, and to learn how to avoid getting caught out!

Tags:   Power BI | Visualisations

Disappearing data labels in Power BI Desktop

Posted by Sam Lowrie on 20 July 2018

Ever had a data label vanish for no apparent reason? This blog gives two of the most common reasons why this might happen.

Tags:   Power BI | Visualisations

Using MERGE and MATCHED in SQL

Posted by Sam Lowrie on 21 June 2018

Learn how to MERGE rows from two tables into one combined table, and how to remove unwanted data from both tables.

Tags:   SQL | Programming tables

Some ideas for company days out!

Posted by Andy Brown on 18 June 2018

Go-karting, axe-throwing, escape rooms and ninja training - some of the ideas from this blog suggesting company days out in Manchester.

Tags:   Musings | Random musings

A summary of recent blogs that we've written on bookmarks in Power BI Desktop

Posted by Andy Brown on 18 June 2018

We've created a few blogs giving some ideas for how to use the new Power BI bookmarks features (including dynamic charts and enabling pagination). This blog brings the links together onto a single page.

Resolving a problem with SSRS and a Windows 10 update

Posted by David Wakefield on 18 June 2018

After installing Windows 10 our laptops started returning a 503 error in Web Portal - this blog shows how to resolve this.

Tags:   SSRS | General

How to get the custodians of your data to give you access!

Posted by David Wakefield on 18 June 2018

GDPR isn't as restrictive as most commentators claim, as this blog sets out to show. Don't let data custodians block you from analysing your corporate data!

Tags:   Musings | General IT

Using the CROSS FILTER function in Power BI Desktop

Posted by Sam Lowrie on 13 June 2018

Learn about the perils of changing the cross filter direction to "Both", then discover why the CROSS FILTER function is better!

Tags:   Power BI | Measures / DAX

Changes in the June 2018 Update of Power BI Desktop

Posted by Andy Brown on 09 June 2018

There are hardly any changes in this update - the only significant one is that you now sort and filter data within Power BI Desktop itself, rather than having to go into Query Editor.

Tags:   Power BI | Updates

More suggestions for how to use bookmarks

Posted by Sam Lowrie on 09 June 2018

Another set of examples showing ways in which to use the weird and wonderful bookmarks feature in Power BI Desktop

Splitting long tables of data into different pages (pagination)

Posted by Sam Lowrie on 01 June 2018

This blog shows how you can split rows in tables into different pages, making the data easier to read.

Tags:   Power BI | Visualisations

How to create dynamic report titles in Power BI Desktop

Posted by Sam Lowrie on 01 June 2018

How you can combine the use of measures and cards to create dynamic report headers in Power BI Desktop.

Tags:   Power BI | Measures / DAX
This page has 0 threads Add post