Forum Discussion
Disable Large Semantic Model Storage Format
- 1 year ago
Datasets - Update Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn
targetStorageMode
Hi ybarsabal ,
Thank you for your question. Power BI does not offer a direct method to disable it once a dataset exceeds Pro limits.
Thank you lbendlin , As lbendlin suggested, you can use the Power BI REST API to update the dataset’s targetStorageMode and revert it to a Pro-supported format.
If the REST API is not an option, consider these alternatives.
- If you have access to Premium Per User (PPU) or Premium Capacity, move the dataset there, disable Large Semantic Model Storage Format, and reduce its size. Once optimized, move it back to the Pro workspace.
- Use aggregations or summarized data instead of detailed records and enable Incremental Refresh to limit historical data. Once the dataset fits Pro limits, you should be able to disable Large Semantic Model Storage Format.
If a Premium workspace is not available, the REST API method is the most efficient solution. Otherwise, migrating the dataset to Premium, optimizing it, and moving it back to Pro is the best manual approach.
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.