Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

0
arpost

Cannot deploy reports with DirectQuery and RLS via deployment pipeline with deployment rules active

Submitted by Post Prodigy on ‎05-13-2022 08:29 AM

I have a report that uses DirectQuery and row-level security that needs to be moved through a deployment pipeline, but I cannot deploy it if I turn on deploy rules for the target workspace. This same parameter rule works just fine for other reports being deployed via the pipeline (and works when set manually on data per note in image below).

arpost_0-1652455990983.png

 

This is really problematic for enterprise-level BI DevOps as RLS is essential to handling sensitive data for our org, and the dataset needs to be updated to use the appropriate database for each pipeline workspace as they correspond to an environment, so Dev = Dev DB, Test = Test DB, etc.

Status: Delivered
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎05-15-2022 10:49 PM

Hi @arpost ,

 

This is a dataset limitation in the deployment pipeline.You can only add to the dataset manually.

  • A dataset with DirectQuery or Composite connectivity mode, that uses variation or calendar tables, isn’t supported.

 

For more information，you may refer to Deployment pipelines process - Dataset limitations 

 

Best Regards,
Community Support Team _ Caitlyn

arpost
Post Prodigy
Post Prodigy
‎05-16-2022 07:25 AM

Ah. Appreciation the clarification. I added this as an idea (link) over on the Ideas board for anyone who wants to upvote this.

Idea Statuses