Code Interpreter GPT-4: Is it cocktails on the beach time?

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 [...]

2023-08-01T12:01:28+08:00ChatGPT, Power BI|

Using Power Query to Consolidate Multiple Files from a Folder

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 [...]

Top tips for Power Query Data Types

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 [...]

Connect to files stored on OneDrive and SharePoint

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 [...]

Hard coded data sources in Power BI

By Eric Marshall Hard coded data sources in Power BI Simple, hard-coded data tables can be useful data sources in Power BI (provided your data won’t change!). Here’s how to incorporate hard-coded data into your data model: Under the Home ribbon of Power BI Desktop, click “Enter Data”.   Double click on “Column1” and rename [...]

2020-04-21T13:34:25+08:00Power BI|