topic Re: Power BI Embedded query parameters in Developer

Power BI Embedded query parameters

Alexander24 — Tue, 25 Apr 2017 19:59:55 GMT

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

Re: Power BI Embedded query parameters

Eric_Zhang — Thu, 27 Apr 2017 06:45:57 GMT

@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

There's no such parameter feature in Power BI Embedded.
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.

Re: Power BI Embedded query parameters

Alexander24 — Thu, 27 Apr 2017 11:44:18 GMT

Thanks Eric, that could be a possibility, just not sure the scalability of pulling in all the facebook pages data, also would be good if the data was live as well,

Anyway thanks for the heads up and advice,

Much Appreciated

Alexander

Re: Power BI Embedded query parameters

Eric_Zhang — Mon, 01 May 2017 09:57:44 GMT

@Alexander24 wrote:

Thanks Eric, that could be a possibility, just not sure the scalability of pulling in all the facebook pages data, also would be good if the data was live as well,

Anyway thanks for the heads up and advice,

Much Appreciated

Alexander

@Alexander24

Just keep one eye on the Power BI Blog, probablly there'll be some new feature for refreshing in Power BI embedded in May.

Re: Power BI Embedded query parameters

Alexander24 — Mon, 02 Oct 2017 13:03:32 GMT

Hi Eric,

Just thinking on this, do you know how you would pull all of the facebook page api data instead of just using one page as normally done in power bi, have you seen this done before?

Thanks

Alexander