PowerBi Pipeline - Analysis Service Deployed Dataset - Change Data Source

[Anonymous]

Hi All,

Can anyone confirm if you are able to use PowerBi Pipelines to change the Data Source on an Analysis Service Deployed Dataset?

I'm getting an error when I try, the Data Source is Azure Synapse DB.

It allows me to configure the the data source rule fine but when I click save, I get error below

Rule property no longer exists.Learn more

Thanks for any help in advance

[Anonymous]

Hey @Anonymous ,
Have you found out the solution to the problem reported? We're facing exactly the same thing now;/

[v-jayw-msft]

Hi @Anonymous ,

Check if it could be caused by the following deployment rule limitations.

https://docs.microsoft.com/en-us/power-bi/create-reports/deployment-pipelines-get-started#deployment-rule-limitations .

This section lists the limitations for the deployment rules.

• To create a deployment rule, you must be the owner of the dataflow, dataset or paginated report you're creating a rule for.

• Deployment rules cannot be created in the development stage.

• When an item is removed or deleted, its rules are deleted too. These rules cannot be restored.

• When you unassign and reassign a workspace to reestablish connections, rules for that workspace are not kept. To use these rules, you'll need to reconfigure them.

• Rules for dataflows that have other dataflows as sources, are not supported.

• Data source rules for common data model (CDM) folders in a dataflow, are not supported.

• Rules for datasets that use dataflows as their source, are not supported.

• If the data source defined in a rule is changed or removed from the item it points to in the source stage, the rule will not be valid and the deployment will fail.

• If the parameter defined in a rule is changed or removed from the item it points to in the source stage, the rule will not be valid and the deployment will fail.

Best Regards,

Jay

[Anonymous]

Does appear to be a limition for the list, unless the list is missing detail for suing with Analysis Services published dataset.

To confirm this I repeated the process using PowerBi Desktop to publish the dataset instead of analysis services.

This worked as expected.

Can anyone confirm if you are able to use PowerBi Pipelines to change the Data Source on an Analysis Service Deployed Dataset?

[Nimrod_Shalit]

Did you try following what the 'learn more' link says?
Alternatively, please check that the connection string you are trying to change still exists in the Dev dataset. It has to exists in the source stage dataset for the rule to be valid.
If everything is OK, please open a support ticket so we can further investigate.

[Anonymous]

Hi,

The 'learn more' link doesn't provide an futhur information to help.

The connection still exists in the origional dev version.

I'll look to get someone to log me a support ticket to.

Thanks