How to Connect Xero or HubSpot to Excel (Step-by-Step Guide for Accountants and Sales Teams)
Looking for an easy way to connect Xero or HubSpot to Excel? This step-by-step guide shows accountants, CFOs, and sales managers how to use a PostgreSQL ODBC connection to pull live data into Excel—without manual CSV exports.
How to Split and Merge Fields in Power BI
Learn how to split and merge fields in Power BI using a real Xero tracking category example. This practical guide shows how to align combined fields like “Region – North” with Excel datasets where values are stored separately, so you can build accurate relationships and consolidated reports. Ideal for accountants and sales managers working with Xero, HubSpot, and Power BI.
How to Create a Running Total and Top N Customers in Power BI with DAX
Learn how to create running totals and highlight top customers in Power BI using DAX. This step-by-step guide shows practical examples for finance and sales reporting, helping you turn raw data into clear, actionable insights.
How and Why to Create Apps in Power BI?
Power BI Apps offer a clean, consistent way to share reports across your organisation without exposing draft content or risking accidental changes. If you manage dashboards for finance, sales, or operations—especially using Xero or HubSpot data—Apps help ensure stakeholders always see accurate, curated insights. This guide explains why Apps matter and how to set them up properly.
How to Expand JSON Data in Power BI Desktop
Learn how to expand JSON fields in Power BI Desktop using HubSpot data. A practical guide with Connectorly for HubSpot & Power BI.
How to Fix the Power BI SharePoint SSL (HTTPS) Error and Connect Files Securely
Connecting Power BI to SharePoint files can sometimes trigger the dreaded “Use SSL (HTTPS)” OAuth 2.0 error — but the fix is simpler than you think. In this guide, Connectorly explains how to securely link your SharePoint files to Power BI, avoid common authentication issues, and ensure your reports refresh smoothly. Ideal for Power BI developers, accountants, and business leaders who want reliable, secure data connections without the headaches.
How to Connect Your HubSpot to Power BI and Get Better Insight on Your Sales
Unlock deeper insights into your sales performance by connecting HubSpot to Microsoft Power BI. In this guide, we show you the easiest way to integrate the two platforms, automate your data flow, and create interactive dashboards that help you track KPIs, identify trends, and make smarter business decisions.
5 Time-Saving Power BI Desktop Tips Every Beginner Should Know
Discover five essential Power BI Desktop tips designed for beginners to streamline tasks and enhance productivity. From quick multi-selection and data transformation techniques to efficient duplication of visuals, these practical strategies ensure your reporting process is both efficient and professional.
Why Accurate Calendar Reporting Matters (And How Connectorly Makes It Easy)
Accurate calendar reporting is crucial for making sense of your financial and sales data—especially when different teams or regions work with different fiscal year definitions. In this post, we explore why flexible calendar options (like ISO weeks, fiscal years, and standard Gregorian calendars) matter, and how Connectorly makes it easy to apply the right structure to your Power BI reports—whether you’re using data from Xero, HubSpot, or both.
How To Manage Credentials and Automatic Refresh in Power BI Online
Keeping your Power BI reports current doesn’t have to be a struggle. This guide walks you through how to securely manage data source credentials and set up automatic refreshes in Power BI Online—so your insights are always accurate, timely, and stress-free.
How to update datasource settings in Microsoft Power BI desktop
https://youtu.be/20N8293ffL4 Managing your data source credentials in Power BI is crucial for maintaining secure and accurate data connections. In our latest video tutorial, we guide you through the process of updating your data source credentials in Power BI, ensuring your reports remain reliable and up-to-date. Why Update Data Source Credentials in Power BI? Power BI […]