Power BI

How to use slicer by column to show different measures
The first step is to create a column of selections for the user to choose from. Note that his table would have no relation to the actual data set. It is...
Wed, 6 Sep, 2023 1:53 AM
Connecting to an Excel file on SharePoint using Power BI
In this article you'll learn how to connect to an Excel file saved on a SharePoint document library. Go to the desired document library on SharePo...
Mon, 27 Feb, 2023 10:37 AM
Connecting to a Sharepoint online list using Power BI
To connect to the your SharePoint Online List, you will need the root URL of your Sharepoint site which is visible on the browser's address bar. I...
Mon, 27 Feb, 2023 10:37 AM
How to connect to BPW on Power BI Desktop
BPW stands for Business Performance Warehouse, which is Kemin's data warehouse. A data warehouse consolidates and integrates data from differen...
Fri, 28 Jul, 2023 11:48 AM
How to Connect to M3 on Power BI Desktop
Mon, 27 Feb, 2023 10:38 AM
How do I know what data source my report is using ?
This article describes how to identify which data source is used by a Power Query or a Power BI file. In Excel, from the main menu, click on Data->...
Thu, 1 Feb, 2024 4:45 PM
How to connect to Excel on Power BI
Mon, 27 Feb, 2023 10:38 AM
How to Publish to Power BI from Microsoft Excel
If you have Microsoft Excel 2016 and later, then you would be able to publish Excel workbooks directly to your Power BI workspace and app. A few thing...
Mon, 27 Feb, 2023 10:38 AM
How to Fix Power BI dataset refresh after MFA is enabled
Once MFA (Multi-Factor Authentication) is enabled at Kemin, it may cause Power BI datasets refresh to fail if those flows are connected to Office 365 servic...
Mon, 2 Oct, 2023 12:31 AM
How to connect to the sales cube with Power BI
This article describes how to connect to the sales cube using Power BI. -> Please note that the sales cube is accessible vie the 'Sales WW'...
Wed, 13 Mar, 2024 5:16 PM