Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
HamidBee
Power Participant
Power Participant

What does a target storage mode set to 'PremiumFiles' mean when writing a PowerShell script?

I'm learning about PowerBI Rest APIs and I came across the following PowerShell script:

 

Set-PowerBIDataset -Id 038f9a64-1fcd-42f2-957a-13a63b3d3235 -TargetStorageMode PremiumFiles

What does a target storage mode set to premium mean?.

 

Thanks in advance. 

1 ACCEPTED SOLUTION
HamidBee
Power Participant
Power Participant

I just found the answer on another page:


"Premium: Premium file shares are backed by solid-state drives (SSDs) and provide consistent high performance and low latency, within single-digit milliseconds for most IO operations, for IO-intensive workloads. Premium file shares are suitable for a wide variety of workloads like databases, web site hosting, and development environments. Premium file shares can be used with both Server Message Block (SMB) and Network File System (NFS) protocols."

 

https://learn.microsoft.com/en-us/azure/storage/files/storage-files-planning#storage-tiers

 

The full script to change the storage mode to premium should look like this:

 

Set-PowerBIDataset -Id <Dataset ID> -TargetStorageMode PremiumFiles

(Get-PowerBIDataset -Scope Organization -Id <Dataset ID> -Include actualStorage).ActualStorage

 

It's very useful to do this for really large datasets. 

 

View solution in original post

1 REPLY 1
HamidBee
Power Participant
Power Participant

I just found the answer on another page:


"Premium: Premium file shares are backed by solid-state drives (SSDs) and provide consistent high performance and low latency, within single-digit milliseconds for most IO operations, for IO-intensive workloads. Premium file shares are suitable for a wide variety of workloads like databases, web site hosting, and development environments. Premium file shares can be used with both Server Message Block (SMB) and Network File System (NFS) protocols."

 

https://learn.microsoft.com/en-us/azure/storage/files/storage-files-planning#storage-tiers

 

The full script to change the storage mode to premium should look like this:

 

Set-PowerBIDataset -Id <Dataset ID> -TargetStorageMode PremiumFiles

(Get-PowerBIDataset -Scope Organization -Id <Dataset ID> -Include actualStorage).ActualStorage

 

It's very useful to do this for really large datasets. 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.