Convert normal published dataset to "Push"

[amarsale85]

Hello Experts,

We have a requirement where each client has its own custom fields like "Client 1" has fields "Column 1" & "Column 2" in a table "Custom Fields". And other client, "Client 2" has field "Column 3" in same table. The LDM and relationship of this table with other tables in the model are same.

Option 1: If i pass Client Id as parameter to get the correct fields relating to that client, works in Power BI desktop but doesn't work on Power BI Service.

To resolve option 1 issue i need to add/update fields using PowerShell cmdlets like "Set-PowerBITable" in the published dataset.

This isn't allowed as that dataset isn't a Push Dataset. So i am stuck here as of now and need some help.

Only Option i have is open the report/dataset in Power BI desktop, then change "Client Id" parameter and apply changes to see fields related to that client in the table, and then publish it for each client/workspace. This isn't ideal solution since we have like 1000+ clients.

Regards,

Amar

[v-alq-msft]

Hi, @amarsale85 

I wonder if there is some error message in Power BI Service. 'If i pass Client Id as parameter to get the correct fields relating to that client, works in Power BI desktop but doesn't work on Power BI Service.'

You can review and edit some parameter settings in the Power BI service -- not parameters that restrict the available data, but parameters that define and describe acceptable values. Even though you modify the parameter, you still need to refresh the data source to get the result. If it still doesn't work, you may try to use api.

For further information, please refer the document .

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.