Forum Discussion

RahulkumarB123's avatar
RahulkumarB123
Frequent Visitor
2 years ago
Solved

PowerBI template apps using dataflow as a data source

Hi ,     we are creating powerBI reports using dataflow as a datasource. now we want create a template app for those reports. My question is how we can set parameter for data flow in template app cr...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi RahulkumarB123 ,

     

    Try to connect to the dataflow in Power BI Desktop and create parameters in the Power Query Editor.

     

     

    In the link you provided there is a jump link that also contains some specific settings and steps for creating parameters: Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power BI

     

    Then you can manage parameters when Add content to the template app workspace in Power BI Service:

     

     

    Best Regards,
    Zhu
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

     

RahulkumarB123's avatar
RahulkumarB123
Frequent Visitor
2 years ago

Hi Zhu,

          Thanks for your reply.

I am following Template app creation process in powerBI services. For that purpose i refer bellow document.

 

Create template apps in Power BI - Power BI | Microsoft Learn

 

---Report that i created used datasource as a Dataflow which i created in powerBI services ( In dataflow i fetched multiple table from business central dynamic 365 using Odata feed connector) . Basically my aim is to create a report packages and publish it in Microasoft app source so others user can downlaod this app connect with there dataflow ( This dataflow need to create first by user side). But when in template app creation i stuck in parameter section ,beacuse this parameter is need to provide by user when they want to use app with tere own data. i dont understand how we can create parameter in power Query to change the dataflow ???

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi RahulkumarB123 ,

 

Try to connect to the dataflow in Power BI Desktop and create parameters in the Power Query Editor.

 

 

In the link you provided there is a jump link that also contains some specific settings and steps for creating parameters: Deep Dive into Query Parameters and Power BI Templates | Microsoft Power BI Blog | Microsoft Power BI

 

Then you can manage parameters when Add content to the template app workspace in Power BI Service:

 

 

Best Regards,
Zhu
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!