Forum Discussion
direct query for mariadb via SQL query to join tables
Hi all, I am new to Power BI and I am trying to get data to create a power BI report via a direct query to a Maria DB. I have two related tables that I would like to join and then import using a spe...
AbhinavJoshi
Responsive Resident
Responsive ResidentHi rbermanmw. Go to Power Query Editor ->New Source -> Get Data. In the source select MariaDB.
Enter the credentials
When you load the tables, you will see your SQL query in the formual section, modify that with your desired query and it should work.
AbhinavJoshi Can you show me a screenshot of the formula section with an SQL query in it?