How to: Connect Power BI to Self-Hosted Bitrix24 MySQL Database Directly
🟢Bitrix24 administrator course:
http://crmforms.emcsoft.io/Bitrix24Ad...
🟢Register your Bitrix24 right now:
https://www.bitrix24.com/create.php?p...
🟠email: [email protected]
🟠web-site: https://emcsoft.io/
🟠Send us a message: https://bit.ly/EMCsoftMarketplaceSupport
🟠Book online meeting: https://calendar.app.google/DS1uf8WwE...
✅Install TwiSMS: https://bit.ly/InstallTwiSMS
1/ How to install TwiSMS: • How to: Install Incoming SMS app in your B...
2/ Troubleshooting TwiSMS: • Troubleshooting Issues with SMS Reception ...
3/ SMS marketing with TwiSMS: • Get More Sales and Conversions with TwiSMS...
✅Install CallCenter24: https://bit.ly/InstallCallCenter24
1/ About CallCenter24: • CallCenter24: Twilio Call Center Solution ...
Creating a Read User in MySQL
1/ go to the server via ssh as the root user
2/ run command to connect to mysql server
mysql
3/ if you can't log in, you need to start with the parameters of the name and password (Bitrix environment, by default allows the root user to connect without a password)
mysql -u USER -p
4/ Next, create a user
CREATE USER 'bi_user'@'78.46.217.174' IDENTIFIED BY 't9wH-K4YcPx3KSc';
5/ Assign him the rights to read the Bitrix table
GRANT SELECT on sitemanager.* TO 'bi_user'@'78.46.217.174' WITH GRANT OPTION;
6/ Update permissions
FLUSH PRIVILEGES;
7/ Exit the database
8/ Create a rule in the firewall to access the Database
mysql from our IP address
iptables -I INPUT -p tcp -s 78.46.217.174 --dport 3306 -j ACCEPT
9/ Save firewall rules for later use
service iptables save
10/ required plugin to load data from MySQL
https://dev.mysql.com/downloads/file/...
Power BI is a powerful business intelligence tool that allows you to analyze and visualize data from various sources. If you are using a self-hosted Bitrix24 instance and want to connect it directly to a MySQL database in Power BI, you can follow these steps:
Verify MySQL Database Access: Ensure that you have the necessary credentials (username and password) and the required privileges to access the MySQL database that Bitrix24 uses.
Install MySQL Connector/ODBC: Download and install the MySQL Connector/ODBC driver on the computer where Power BI is installed. This driver acts as a bridge between Power BI and the MySQL database. Make sure to choose the appropriate version based on your operating system.
Configure ODBC Data Source: Open the ODBC Data Source Administrator on your computer. In the System DSN tab, click "Add" to create a new data source. Select the MySQL ODBC driver and provide a name for the data source. Configure the necessary connection details such as server address, port, username, password, and the specific database you want to connect to.
Test the Connection: Click on the "Test" button in the ODBC Data Source Administrator to verify the connection to the MySQL database. If successful, you should see a confirmation message.
Open Power BI: Launch Power BI Desktop on your computer.
Connect to the MySQL Database: In Power BI Desktop, click on the "Get Data" button in the Home tab. Search for and select "MySQL database" from the available data source options.
Provide Connection Details: In the MySQL database connector window, enter the server address, port, and database name. Choose "ODBC" as the connection method and select the data source name (DSN) you created in step 3. If required, enter the username and password for the MySQL database.
Connect and Import Data: Click "Connect" to establish the connection to the MySQL database. If the connection is successful, you will be able to select the tables or views you want to import into Power BI. Choose the relevant tables and click "Load" to import the data into Power BI.
Build Visualizations: Once the data is imported into Power BI, you can start creating visualizations, reports, and dashboards based on your requirements.
Fill out this form:
https://b24-czcr1k.bitrix24.site/Bitr... if you want to participate in our upcoming course Bitrix24 Administrator
email: [email protected]
web-site: https://emcsoft.io/
register your Bitrix24 right now:
https://www.bitrix24.com/create.php?p...
Send a message
directly from your Bitrix24: https://bit.ly/EMCsoftMarketplaceSupport
#Bitrix24 #PowerBI #DataVisualization