Forum Discussion
PowerBI semantic model's parameters get removed/not recognized after uploading through API
Hi theflashczech,
Thank you for reaching out in Microsoft Community Forum.
Please follow below steps to resolve the error;
1.When deploying PBIX via PowerShell, parameters may not get promoted to the dataset metadata, causing the API to return an empty list.
2.Manually publish the PBIX once using Power BI Desktop to verify if parameters appear via the API.
3.Migrate to PBIP (Power BI Project) format for better DevOps support, where parameters are fully supported and accessible via REST APIs.
4.Use the GetDataset API to ensure the dataset is properly loaded and not in a partial or invalid state.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.
Super UserThere is a example script for PBIP format
https://learn.microsoft.com/en-us/rest/api/fabric/articles/get-started/deploy-project
https://github.com/microsoft/Analysis-Services/tree/master/pbidevmode/fabricps-pbip
Are you using this API to check if the parameters exist?
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-parameters-in-group
Are you able to connected to the deployed sematic model with Tabular Editor to check if everything looks like it should?
Hello,
I apologize for the delayed response, I've looked into your points:
Yes, we are using the endpoint to check whether they exist, the result is negative though as only an empty list is returned.
Yes, we're able to connect through tabular editor, the parameters seem to be existing in the file itself but they are not being returned when requested through API, neither for reading nor editing.
Hi theflashczech,
Thank you for reaching out in Microsoft Community Forum.
Please follow below steps to resolve the error;
1.When deploying PBIX via PowerShell, parameters may not get promoted to the dataset metadata, causing the API to return an empty list.
2.Manually publish the PBIX once using Power BI Desktop to verify if parameters appear via the API.
3.Migrate to PBIP (Power BI Project) format for better DevOps support, where parameters are fully supported and accessible via REST APIs.
4.Use the GetDataset API to ensure the dataset is properly loaded and not in a partial or invalid state.
Please continue using Microsoft community forum.
If you found this post helpful, please consider marking it as "Accept as Solution" and give it a 'Kudos'. if it was helpful. help other members find it more easily.
Regards,
Pavan.