i have url returns json object need power bi embedded report. data report adding new web data source , pasting url in. few transformations later , tada! sexy report. report shows lots of charts , graphs etc... need able change datasource url depending on looking @ it.
the report shows data single organization. can @ if you're in organization. how can pass organizations id when embedding report datasource show different data?
for example if datasource defined in originating pbix as
json.document(web.contents("http://www.testdata.com/api/json?orgid=1")) how can change
json.document(web.contents("http://www.testdata.com/api/json?orgid=2")) when i'm pull report embed on page?
i know can filter data means have make datasource url pull data huge , intensive have bi filter out something.
in short, i'm embedding report on website , tat report's way data via json endpoint. endpoint requires org id of user how pass bi in turn uses in data source url?
your option scenario pull required data dataset. can use either role level security (rls) or new js api filter data each user.
you should @ azure sql data source more efficient, flexible , scalable back-end pbi embedded.
Comments
Post a Comment