I did not find a way to generate reports by executing SQL queries directly on database in power BI. I am new to this tool and surprised that we dont have such capability in it.
I have a reporting requirement where I need to generate reports on the fly (Without predefining model in powerBI) by executing direct queries against database.
I am dealaing with 1 TB data to import it in powerBI is not feasible so I want to execute queries on source database itself rather than building model and in powerBI.
Do we have any API level interface to generate reports programatically in powerBI? I did not find much help on this topic.
is it possible in power BI to generate reports by directly executing queries against database without replicationg / importing data to powerBI.
Also is it possible to generate report programatically by passing parameters in report arguments.
e.g.
https://powerbi-report-url/reportid¶m1=value1 etc.
Please suggest if any workaround is there for this requirement.