SoftOne BI
If you are looking to connect to the SoftOne BI data source from inside Power BI, then you need to use the Power Query M language code. This code will allow you to establish a connection with the desired data source and retrieve the data you need. In this article, we will provide you with a step-by-step guide on how to use the Power Query M language code to connect to the SoftOne BI data source from inside Power BI.
Step 1: Open Power BI Desktop
The first step in connecting to the SoftOne BI data source is to open Power BI Desktop. Once you have opened Power BI Desktop, click on the “Get Data” button on the Home tab.
Step 2: Select the SoftOne BI Data Source
After clicking on the “Get Data” button, a window will appear with a list of data sources. In this window, you need to select the “SoftOne BI” data source.
Step 3: Enter the Server and Database Information
Once you have selected the SoftOne BI data source, you need to enter the server and database information. This information can be obtained from the SoftOne BI administrator. Enter the server name, database name, and any other necessary information.
Step 4: Enter the Power Query M Language Code
After entering the server and database information, you need to enter the Power Query M language code. This code will allow you to establish a connection with the SoftOne BI data source and retrieve the data you need. Here is an example of the Power Query M language code you can use to connect to the SoftOne BI data source:
let
Source = Sql.Databases(“server name”),
dbo_SoftOneBI = Source{[Name=”database name”]}[Data],
dbo_TableName = dbo_SoftOneBI{[Schema=”dbo”,Item=”TableName”]}[Data]
in
dbo_TableName
This code will connect to the SoftOne BI data source and retrieve data from the “TableName” table. You can modify this code to retrieve data from other tables as well.
Step 5: Load the Data
After entering the Power Query M language code, you need to load the data into Power BI. To do this, click on the “Load” button at the bottom of the window. Power BI will then retrieve the data from the SoftOne BI data source and load it into the report.
Conclusion
In this article, we have provided you with a step-by-step guide on how to use Power Query M language code to connect to the SoftOne BI data source from inside Power BI. By following these steps, you can establish a connection with the SoftOne BI data source and retrieve the data you need for your report.
