Forum Discussion

Mitchvdd's avatar
Mitchvdd
Frequent Visitor
5 years ago

Deployment Pipelines -Datasource rules for Power BI Report with the connection to a Power BI Dataset

I am currently investigating to use Deployment Pipelines for the deployement of Power BI Reports. These reports have a live connection with a Power BI Dataset which is placed in a separate workspace ...
Need Help
Nimrod_Shalit's avatar
Nimrod_Shalit
Icon for Power BI Team rankPower BI Team
5 years ago

Mitchvdd,

unfortunatley, this is still not possible yet.

We are planning to close this gap by the end of the year.

In the meantime, a possible workaround would be to set all reports to connect to the PROD dataset, and have local reports within the dataset pipeline, where you can test changes in the datasets. 

Another option is not to manage the dataset in a pipeline, and use it for reports only.

  • Mitchvdd's avatar
    Mitchvdd
    Frequent Visitor
    5 years ago

    I'm happy that this is a gap you would like to close, but until this is possible I'm unable to use the Deployment Pipelines (which I personally am a big fan of!). However, it works very well for Power BI Dataset in combination with datasource rules. 

     

    When you have local reports within the workspaces connected to another datasource it's not possible the push a report from DEV to ACC with Deployment Pipelines. So the problem is not with datasets, but with reports...

  • juancho182's avatar
    juancho182
    New Member
    4 years ago

    Hi Nimrod_Shalit as we are in Q4 now, any updates on this topic? Can I use deployment pipelines to point live connections to DEV, QA and PROD respectively?

     

    Thanks,

  • FritzVPL's avatar
    FritzVPL
    Icon for Advocate II rankAdvocate II
    2 years ago

    Hi Nimrod_Shalit Mitchvdd Does anyone know if this is still not possible? I have the same scenario of connecting to live pbi datasets in other workspaces as well, and it is still not giving me the option to change the deployment rules so I can connect to the correct PBI dataset as it goes through the pipeline. Has it really not been delivered almost 2.5 years later or am I missing something?