The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I tried to use RLS with PowerBi embedded analytics. I followed steps from
This is my code to generate tokens:
public EmbedToken GetEmbedToken(Guid reportId, IList<Guid> datasetIds, [Optional] Guid targetWorkspaceId)
PowerBIClient pbiClient = this.GetPowerBIClient();
// Create a request for getting Embed token
// This method works only with new Power BI V2 workspace experience
var tokenRequest = new GenerateTokenRequestV2(
reports: new List<GenerateTokenRequestV2Report>() { new GenerateTokenRequestV2Report(reportId) },
datasets: datasetIds.Select(datasetId => new GenerateTokenRequestV2Dataset(datasetId.ToString())).ToList(),
targetWorkspaces: targetWorkspaceId != Guid.Empty ? new List<GenerateTokenRequestV2TargetWorkspace>() { new GenerateTokenRequestV2TargetWorkspace(targetWorkspaceId) } : null,
identities: new List<EffectiveIdentity> { { new EffectiveIdentity(username: "*****", roles: new List<string> { "***" }, datasets: new List<string> { datasetIds.ToString() }) } }); ;
// Generate Embed token
var embedToken = pbiClient.EmbedToken.GenerateToken(tokenRequest);
return embedToken;
}
But I get the following error
Solved! Go to Solution.
Hi @Anonymous ,
Please check whether the parameters like report id/dataset id in your code are correct.
I think you can try to post a Rest API to generate a Embed token for the report with RLS.
For refernece: Embed Token - Generate Token - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Here is a solved post with similar issue like yours, I think you may refer to it to learn more details.
Solved: Re: Power BI send “invalid status code 'Bad Reques... - Microsoft Power BI Community
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Please check whether the parameters like report id/dataset id in your code are correct.
I think you can try to post a Rest API to generate a Embed token for the report with RLS.
For refernece: Embed Token - Generate Token - REST API (Power BI Power BI REST APIs) | Microsoft Docs
Here is a solved post with similar issue like yours, I think you may refer to it to learn more details.
Solved: Re: Power BI send “invalid status code 'Bad Reques... - Microsoft Power BI Community
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
5 | |
2 | |
2 | |
2 | |
2 |
User | Count |
---|---|
11 | |
7 | |
5 | |
4 | |
4 |