Community

I need to test the upload of power bi [pbix, rdl] files in my application. I need to create PowerBI reports that connect to a SQL server data source. There would be no change to the table scheme. However, the connection string will always vary. Is there a way to automate the creation of reports? For ease of creation, I have parameterized the connection details and saved the report in .pbit format. But, I need to create these reports run-time. I have been using Power Bi desktop for creating the reports. I am also Selenium as the tool for interacting the browser.