Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
I need to prepare a list of all datasets in a given Power BI org and each dataset's metadata (created date, last refreshed, workspace, endorsement, owner, etc.) just like is presented on the Datasets tab of the PBI Service. However I need this list in an analyzable form such as in Excel, CSV, etc. Is there any way to do this? If not, is there an easy way to get a count of datasets based on the year of their last refresh date?
Solved! Go to Solution.
Hi @keobrie ,
You could try toget dataset list with PowerShell.
Get-PowerBIDataset
[-Scope <PowerBIUserScope>]
[-Filter <String>]
[-First <Int32>]
[-Include <String>]
[-Skip <Int32>]
[-WorkspaceId <Guid>]
[<CommonParameters>]
To learn more details and operations ,refer:
Get dataset list with PowerShell
Exporting the workspaces list from the Admin Portal
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi @keobrie ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
Hi @keobrie ,
You could try toget dataset list with PowerShell.
Get-PowerBIDataset
[-Scope <PowerBIUserScope>]
[-Filter <String>]
[-First <Int32>]
[-Include <String>]
[-Skip <Int32>]
[-WorkspaceId <Guid>]
[<CommonParameters>]
To learn more details and operations ,refer:
Get dataset list with PowerShell
Exporting the workspaces list from the Admin Portal
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
The Power BI Data Visualization World Championships is back! It's time to submit your entry.