08 6210 8500
by Wyn Hopkins Setting up a free Personal Power BI Account Do you want to try out the Power BI Service (PowerBI.com) or share your portfolio of reports with potential new employers? If you have a PowerBI.com account then you can use the Publish to Web option to share your reports, but signing up [...]
by Wyn Hopkins Instant Analysis with Code Interpreter and ChatGPT Take 8 Excel files, write 2 instructions ( 25 words in total ), done…data summarized and charts built! Go to OpenAI.com GPT -4, enable Code Interpreter Write 1 sentence and upload folder of data (do not use sensitive data) Here’s the content of the zipped [...]
by Wyn Hopkins Wordle for Power BI Fans We've updated the Wordle Game for all our Power BI Fans out there. All the words are related to Power BI in some way. Click on the file below to play along! *Word of caution though, the file won't open on iPhones. Download a copy of [...]
by Wyn Hopkins Combining Multiple Files from a Folder How to use Power Query for Excel and Power BI to consolidate multiple files into a single table of data, whether you're using OneDrive , SharePoint or a traditional network folder. As well as showing the basic steps, this video explains the inner workings of the [...]
by Wyn Hopkins Tips & Tricks to using Power BI There are several tricks to using Power BI that aren't always obvious. In this video we show you some of the hidden gems: Create a Measures Table Create Folders for your Measures Drag Measures between Tables (and Folders) Add brackets to negative numbers Consolidate multiple [...]
by Wyn Hopkins Granting access to reports Adding a Power BI report to Teams is straight forward, but granting access can be a challenge. For more on this topic check out our blog article Securely sharing Power BI in Teams
by Wyn Hopkins Brief guide for Power BI users A brief guide for users of Power BI reports. This is a brief guide for users of Power BI reports and not a guide on how to build Power BI reports. This is aimed to help users of Power BI dashboards and reports to understand how [...]
by Eric Marshall Assigning Data Types Assigning data types is an essential step when working with Power Query in Excel or Transform Data in Power BI Desktop. Here are some useful tips on how to change data types while maximising the efficiency of your models: Tip #1: Don’t Change Types Until the End of a [...]
by Wyn Hopkins Create Power BI themes using the Adobe colour wheel You can create your own Power BI Themes but knowing what colours to use is a challenge. Adobe colour wheel can help. Want to learn more? Jump on to one of our courses We've trained over 1,000 people from all types of [...]
by Wyn Hopkins Power BI - Prepare for the new Ribbon Per the 2020 Power BI planned release notes the new ribbon, that has been in preview for several months, will be switched on by April 2020 for everyone. Check out the update from Microsoft here. You can turn it on now by going to [...]
by Wyn Hopkins How to use Power Query to connect to a file on OneDrive or SharePoint A growing number of organisations are starting to store their files on OneDrive for Business and SharePoint. Users will begin to discover that connecting to these files with Power Query is not as straight forward as clicking the button for [...]
by Wyn Hopkins Securely sharing Power BI in Teams Embedding a Power BI report inside your Teams channel is a great way of sharing reports and discussing them during meetings. Adding a Report to Teams To add a report, just click the + sign at the top of your Teams Channel window and then [...]
Pay my invoice
