Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Change Source Datflow ID in PBI Desktop Navigation

Hey Everyone!

 

So I use a template for reports and when a new report is requested, i use this and just manually go in and change the bnavidation to the dataflow. The data flow is also templated as in all columns are the same the only thing that changes is the dataflow ID.

 

 

Is there a way that i can just change the Dataflow ID circled in Red in the Navigation part of Power BI instead of manually navidating to the dataflow and selecting each table?

 

I did give this a go but got the error, it seems liek something that should work, but i dont know why it won't.

 

any help would be greatly appreciated as this would speed things up greatly.

 

Thanks 🙂

 

General Comment
Need Help
Tips and Tricks
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi ,  Anonymous 

    According to your description, you are connecting to the dataflows in Power BI Desktop.

    I test it in my side , we can see the detailed M code in the "Advanced Editor" in Power Query Editor:

    We can see in this M code that before we use datflowID, another variable is actually used, and it contains the corresponding workspace ID. This may be why your DataflowID cannot be found. So if you need to modify the M code to directly find your dataflow table, then you may need to modify the variable information that contains the application.

     

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

     

2 Replies

  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    Community Support
    3 years ago

    Hi ,  Anonymous 

    According to your description, you are connecting to the dataflows in Power BI Desktop.

    I test it in my side , we can see the detailed M code in the "Advanced Editor" in Power Query Editor:

    We can see in this M code that before we use datflowID, another variable is actually used, and it contains the corresponding workspace ID. This may be why your DataflowID cannot be found. So if you need to modify the M code to directly find your dataflow table, then you may need to modify the variable information that contains the application.

     

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi v-yueyunzh-msft 

       

      Thank you for this, I can confirm if i go into the advanced editor and amend the bt highlighted in Yellow then this does work 🙂

       

       

       

      Thank you for your help!

       

      Rob