how to modify report query where condition pragmatically

[shan]

I have a multi-tenant application, My approach is, for each tenant I will create a separate workspace in online power bi and upload report from desktop power bi. The reports are stored as .pbix file. The reports are same for all clients only different is in the query, I hardcoding tenant condition (like where tenantid =xxxxxx). For each new tenant signup, I will manually create a workspace and open report in power bi desktop and change the tenant condition, then be uploading to the new workspace.

Now I planning to do this programmatically, but I stuck on how to I can modify the report query where condition programmatically and uploading to workspace

[Anonymous]

Hi @shan,

>>Now I planning to do this programmatically, but I stuck on how to I can modify the report query where condition programmatically and uploading to workspace

I'm afraid that you can't achieve this operations. Current power bi only support to manually choose the publish workspace.

Maybe you can try to submit this to ideas forum.

Regards,

Xiaoxin Sheng

[shan · Accepted solution]

Thanks for your reply. based on the link (click here) we can upload the file to online power bi