troubleshootbi.hashnode.dev·Nov 18, 2022 · 4 min readHow to get data into Power BI using an APIPower BI Level: Intermediate In this article, I am going to go through the steps needed to authenticate and pull in data from a 3rd Party application via API into Power BI. If, like me, you've found yourself tasked with pulling data from an API with...00
troubleshootbi.hashnode.dev·Aug 26, 2022 · 2 min readHow to resolve a data parsing error for time in Power BIToday on the blog, I'm going to explain how to handle an error that can come up in Power BI when trying to process data in the "Time" format. Have you ever run into this error when trying to convert a column to Time format in Power BI? Expression er...00
troubleshootbi.hashnode.dev·Aug 3, 2022 · 3 min read3 Tips for Power BI report optimisationIs your Power BI files making your laptop slow & taking up all your CPU? Report taking 1 million billion years to load? Here are 4 tips on how to optimise the performance of your reports in Power BI desktop. 1. Load a small selection of your data i...00
troubleshootbi.hashnode.dev·Jul 27, 2022 · 2 min read4 Custom visuals to use in Power BI to improve data visualizationThere are about 40 default (out-of-the box) visuals available for use in Power BI reports. There are more custom visuals available in the Microsoft Appsource and Power BI that have been created by Microsoft or Microsoft partners. These have been te...00
troubleshootbi.hashnode.dev·Jun 29, 2022 · 5 min readConditional formatting with thresholds in Power BIConditional formatting is an easy way to highlight values so report users can receive quick insights on the status of key metrics. In this post, I will be showing a way to apply dynamic conditional formatting on visuals with set thresholds. This will...00