This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Wise Owl blogs written by Sam Lowrie (page 1 of 2)

Showing blogs 1-20 (out of 40)

Import custom icons into Power BI

Posted by Sam Lowrie on 02 December 2024

Icons can add a little extra something to your reports. Working out how to do this using JSON files is tricky and in this blog we will cover how!

Tags:
Power BI > General

Connecting to the UK Bank Holiday API

Posted by Sam Lowrie on 31 October 2024

Pull through the official list of Bank Holidays in the UK.

Tags:
Power BI > Dates and calendars

Change multiple measure definitions at once

Posted by Sam Lowrie on 30 September 2024

Updating a measure definition is easy but what happens when you have 200 to update? This blog guides you through using the Dax Query View to achieve this.

Tags:
Power BI > Measures / DAX

Pull data from a Power BI table using Power Automate

Posted by Sam Lowrie on 23 September 2024

Use Power Automate to pull data from Power BI using a DAX query.

Tags:
Power BI > Data sources Power Automate > General

Adding a last refresh date to Power BI reports

Posted by Sam Lowrie on 09 September 2024

Add report refresh date

Tags:
Power BI > Data sources

Dynamic Measure Formatting

Posted by Sam Lowrie on 09 September 2024

When using more complex measures there may be a need for each to be formatted differently. This blog shows you how to use the dynamic formatting measure feature.

Tags:
Power BI > Measures / DAX

Tips for using Power Automate (Web)

Posted by Sam Lowrie on 04 April 2024

Despite the new flow designer in Power Automate going live several months ago, there are still “features” (read bugs) that can cause confusion. This blog covers 5 of these quirks, showing a way to deal with each.

Tags:
Power Automate > General

Google Sheets: 5 reasons you should be using them

Posted by Sam Lowrie on 21 July 2023

This blog lists 5 reasons why you might like to consider using Google Sheets (perhaps as an alternative to Excel?).

Tags:
Google Sheets > General Google Scripts > General

Finding out which Power BI tables and columns aren't being used

Posted by Sam Lowrie on 30 January 2023

How to use Radacad's clean-up tool to see which of the columns and tables in your Power BI data model you're not using.

Tags:
Power BI > Data sources

5 short tips for Power BI

Posted by Sam Lowrie on 19 July 2021

Sometimes our Owls come across little titbits that aren't big enough to count as a full meal. Instead we bide our time and create a smorgasbord of little bites for you to feast on. With that in mind, here are 5 Power BI tips that you might not know.

Tags:
Power BI > General

Power BI Channels you should watch

Posted by Sam Lowrie on 01 July 2021

There are many great resources for learning Power BI, and so many of them are completely free! Level up your BI skills with some of the best. Here Sam covers some of his favourite BI channels. You even get a glimpse behind the curtain to see other channels he watches!

Tags:
Power BI > General

Practise SQL in your browser with SQL Fiddle

Posted by Sam Lowrie on 30 June 2021

Some of our poor delegates don't have the luxury of a home computer to install SQL on (even worse some have made bad life choices and picked a Mac). The good news is that you can still practise your SQL skills in your web browser, using the impressive SQL Fiddle site. Have no fear, SQL Fiddle is here, a browser based sandbox to bring you cheer!

Tags:
SQL > General

What to do when you get red squiggly lines in SSMS and no Intellisense

Posted by Sam Lowrie on 28 April 2021

Normally when SQL Server Management Studio underlines words with what Microsoft call "red squigglies" it's because you haven't refreshed your local cache, but it could also be because of a recent bug - here's how to get round this!

Tags:
SQL > General

Solving FAILED TO DECRYPT CREDENTIALS message when running Power BI

Posted by Sam Lowrie on 20 April 2021

Following the April 2021 update to Power BI (perhaps coincidentally) we started getting this message appearing on our computers, blocking us from running Power BI. Here is how to solve this!

Tags:
Power BI > General

Two easy ways to create themes in Power BI without needing to write JSON

Posted by Sam Lowrie on 30 October 2020

This blog show two ways in which you can create custom themes in Power BI without needing to learn how to write JSON: either use the built-in theme editor in Power BI, or use the theme generator from Power BI Tiips.

Tags:
Power BI > General

This blog shows you how to connect to Remote Desktop if you're using a Mac

Posted by Sam Lowrie on 30 October 2020

Most people attending our online training courses use Windows computers, but the odd Mac user slips through! This blog explains how you can connect to Remote Desktop on a Mac, and so still enjoy your Wise Owl online training.

Tags:
Training > Online training

5 horrible SQL jokes and one puzzle

Posted by Sam Lowrie on 15 November 2023

Sam has a terrible sense of humour which is all too often inflicted on his delegates. Sadly, with this blog, on website viewers too ...

Tags:
SQL > General

Use VBA to create Microsoft Team meetings

Posted by Sam Lowrie on 26 June 2020

Did you know that you can create Microsoft Team meetings using VBA in Outlook? This blog shows you how!

Tags:
VBA macros > General

Writing an App in Power Apps

Posted by Sam Lowrie on 26 June 2020

Sam was tired of getting told off for crinkled or missing expense receipts. So he had a look at Power Apps and this is what he found…

Tags:
Power BI > General

FAQ - questions (and answers) about how our online training works

Posted by Sam Lowrie on 19 June 2020

This blog answers some of the frequently asked questions about how our online training works (such as what software and hardware you'll need, and what freebies are included!).

Tags:
Training > Online training

This page has 0 threads

Add a new post

BLOGS BY TOPIC

BLOGS BY AUTHOR