Forum Discussion

amsrivas's avatar
amsrivas
Helper IV
5 years ago

Power BI Dataset name

Hello Folks!!   Is there any way to display Power BI Report Dataset name in the same Power BI Report.   Thanks Amit Srivastava
Need Help
amsrivas's avatar
amsrivas
Helper IV
5 years ago

Hi avatorl 

 

Agreed with you that, just to add report name or dataset name, its not great idea to use REST API and other stuffs.

 

Just to dig in more, is there any way out to display report name or Dataset name with the help of Powershell.

 

Any idea??

 

Thanks

Amit Srivatava

avatorl's avatar
avatorl
Impactful Individual
5 years ago

> is there any way out to display report name or Dataset name with the help of Powershell.

You can use Powershell to run (e.g. by a schedule) a simple script based on Power BI Cmdlets (just a few rows of code to get report or dataset name) and you can save the name obtained by the script into one of your data sources (e.g. database). You also can compare current report/dataset name with previous version of the name (stored in the database) and if it's different you can initiate dataset refreshing. It's not really complicated but, again, does it make sense? Why do you need to display report/dataset name?

P.S. Or you can use Power Automate + REST API. I see no reasonable way to do that without using the API, there are just different ways to call the API (via data connector, PowerShell, Power Automate, etc.)

  • amsrivas's avatar
    amsrivas
    Helper IV
    5 years ago

    This requirement is important as detailed below.

    I have paginated report (Power BI Builder Report) that is using Power BI Dataset as a source.

    Power BI Report needs to be updated quite frequently (because of chnages in business requirement) and report is managed with suffix as V1 , V2 etc.

    And Paginated report need to be referered to most updated version.

    Just to get rid of version gap, requirement is to diplay the name of the Dataset name in the report so that people will know Paginated report is in sync with Power BI.

    Just to display Power BI Dataset name in Paginated report, i need to add Dataset Name in Power BI existing or new Dataset so that Paginated report will refer that easily.

    I dont mind, if you have any other way out to display Datasource name in Paginated report.

    My ultimate goal is to display name of the Power BI dataset name in Paginated report which it is refering to.

     

    Hope that clarifies 

     

     

    Please suggest!!

    Thanks

    Amit Srivastava 

    • avatorl's avatar
      avatorl
      Impactful Individual
      5 years ago

      >report is managed with suffix as V1 , V2 etc

      Does it mean you have multiple copies of the report in the workspace?
      V1, V2 etc at the same time? How do you creates these copies of the report (e.g. do you rename pbix file before publsihing new version)?

      If you need report version inside of the report (dataset) you can just add a table in Power Query with versions history or you can use a parameter just to store actual version number. Update the tabel or the parameter before report publishing.

      • amsrivas's avatar
        amsrivas
        Helper IV
        5 years ago

        Hi avatorl 

        Yes, we are maintaining multiple version of the report.

         

        If you need report version inside of the report (dataset) you can just add a table in Power Query with versions history  : But this will be a manual process? need to automatized the process in this regards.

         

        Thanks

        Amit

         

    • lbendlin's avatar
      lbendlin
      Super User
      5 years ago

      That is not how you do version control. Use Github or similar to properly implement version control of your reports.