Dynamically change data source of power BI report based on user input

[mohit90]

We have a requirement where user will navigate to our MVC website, will select search criteria. Based on search criteria a csv file will be generated in blob with the help of azure data lake analytics. For each search, output file will be different. Can we use power BI here to show output csv from blob directly embedded in our application ? Same power BI report with different data source for each search.

[v-yuezhe-msft]

@mohit90,

What is the type of your blob? And does your application provide rest API or OData Service to get data? If the OData or rest api of your application is available, you can directly use OData Feed or web connector in Power BI Desktop to connect to your data source and get data.

In addition, is it possible to list all the names of the generated csv files? If it is possible, you can create a parameter(e.g. csvname) listing all the names, then use the parameter in Advanced Editor as shown in the following screenshots.





Regards,
Lydia

[mohit90]

CSV files will be generated at run time based on filter criteria choosen by user at run time. Our solution is REST based API. 

Before showing report to user, we will get the csv file name which will be generated at run time. 

[v-yuezhe-msft]

@mohit90,

You would  need to check how to use the REST API to get data, then directly connect to the API in Power BI Desktop. There is a blog for your reference.

http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/

Regards,
Lydia