I have built a powerapp which allows me to select a database, then a schema, then a table from that schema and then select the columns within that table. This allows me to view the report based on what I have selected. The powerapp is using a SQL server connection.
I would like to pass/add this powerapps to power BI and use this powerapps to do the above but then display my data in power BI in a table. I basically want to allow the user to build their own tabular reports in power BI.