Need help with dynamic query generation and execution in PowerBI

Hello Experts,

I am seeking help in generating dynamic query and automatic execution of the same in Power BI. Below is the scenario I want to achieve 

1. User has slicer which is having names of columns from multiple tables which can have joins among them

2. User selects column names from multiple tables using this slicer

3. Using the selected column names, a dynamic query is generated e.g (select customerID, customerName, OrderId, OrderType, OrderAmt from Customer left Join Order on Customer.CustomerID = Order.CustomerID where CustomerID = 'XXXXXXXX')

4. Then this query is automatically executed in the background and the resultant data is loaded into a dataset

5. The resultant dataset is binded to a table visual with all columns selected

I tried using Dax measure to generate dynamic querystring involving one table, however I am not able to

a. find options to execute this query automatically and bind it to dataset

b. generate dynamic query containing selected columns with join condition

Thank You