Power BI
You may refer to this article to connect to the data.
Mon, 20 Mar, 2023 12:06 AM
Before accessing M3 data reporting you’ll need to make sure your account has been granted with necessary access rights. To do this you can proceed as foll...
Mon, 3 Apr, 2023 9:48 AM
Introduction
Power BI and Power Query are powerful tools for data analysis and visualization, allowing users to connect to various data sources, transform...
Fri, 30 Aug, 2024 1:58 AM
The database sql-mgi-dwh-datamarts contains tables organized as a star schema.
On Excel select Data->Get Data-> From SQL Server Database
...
Fri, 6 Sep, 2024 10:03 AM
Object-level security (OLS) in Power BI is a feature that allows you to control which objects in a model users can see and interact with. This includes tabl...
Mon, 2 Dec, 2024 12:38 AM
Open Power BI or Excel, and select Data tab.
1. Go to Get Data->From Database->select From SQL Server Database.
2. Key in the Server an...
Tue, 30 Jan, 2024 10:22 PM
1/click on Data
2/click on the small arrow on the “get data” button to open the list of options
3/ click on Launch power query editor
...
Tue, 26 Mar, 2024 5:55 AM
This article explains how to migrate a Power Query or Power BI report from m3livedata.kemin.com to m3data.kemin.com.
If you want to know more about n...
Mon, 2 Sep, 2024 3:58 AM
In Power Query Editor, Select Add Column-> Custom Column to calculate the actual time based on ticket region.
2. Key in the Reg...
Sat, 27 Apr, 2024 11:53 PM
In case users notify that the Power BI data gateway is unreachable (see screenshot below)
the Power BI administrators can check the sta...
Thu, 23 May, 2024 5:53 AM