Power BI Embedded query parameters

---

Alexander24 wrote:

Hi There, 

 

Can someone advise if you can pass query parameters into a power bi embedded application, 

 

I am using an API as a data source, i.e i would like an end user to be able to type a parameter which will call the correct data source in the API call

 

I cant pull in all the data and use RLS, as the data is coming from Facebook API

 

Thanks

Alexander

---

1. There's no such parameter feature in Power BI Embedded.
2. The facebook data in Power BI Embedded won't refresh after uploading to azure workspace. Not to metion accepting a parameter and calling the API to retrive individual data. For "refresh" feature, at this moment, only Direct Query mode to Azure SQL DB/DW are supported. Check more in Power BI Embedded FAQs.

So a promising apporach for your case I can think of is pulling all the data,  for example, create a C# console application calling the facebook API and send/update data in a Azure SQL DB, set the application running in a certain interval. And then creating a report connecting to Azure SQL DB and apply RLS accordingly.