Forum Discussion

amsrivas's avatar
amsrivas
Icon for Helper IV rankHelper IV
5 years ago
Solved

Get-PowerBIWorkspace Power BI CMDLET commands

Hi Folks!! I need to find the Power BI related data such as Workspace, Dataset, Dataflow, reports and Users of Power BI. To achieve desired result, i have executed below commands in PowerShell Get...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    Yes. We are auditing our environment via that method, and it works well enough. You don't get page level report usage statistics, but that's the only drawback so far.  Ok, and you don't get XMLA endpoint access audits - but hopefully they add that soon.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Powershell calls return objects. You can then drill into the individual objects to get their properties. What will be really hard is to put all of that into one flat table. How should that even look like?  Better get the individual attributes as needed. 

  • amsrivas's avatar
    amsrivas
    Icon for Helper IV rankHelper IV
    5 years ago

    Hi lbendlin ,

    What i am not able to uderstand is WHY no data is available for below columns using Get-PowerBIWorkspace -All | Fl *

    • Reports
    • Dashboards      
    • Datasets            
    • Dataflows         
    • Workbooks

    Also, how to retreive data for individuals object and make a relationship between them.

     

    Also, I have noticed if i am using any command to retreive data while passing parameter, it got failed after 200 records , a sort of limitation.

     

    Please suggest how to accomplish my requirement.

    My requirement is : To have complete data for Power BI that include workspace, dataflows, datasets , reports , user etc and if individual sets, then there must be relationship between them.

     

    Thanks

    Amit 

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      5 years ago

      What are you actually trying to achieve? Do you want to document/audit your tenant?

      • amsrivas's avatar
        amsrivas
        Icon for Helper IV rankHelper IV
        5 years ago

        Hi lbendlin 

        I want to create a Power BI report in which i can track complate detail of Power BI Report such as 

        Workspace -> Dataflow -> Dataset -> Report -> Users etc.

         

        To acheive above requirement, i need data at the backend.

         

        Thanks

        Amit