Disable Large Semantic Model Storage Format

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.

1. 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.
2. 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.

Hi ybarsabal ,

We noticed we haven't received a response from you yet, so we wanted to follow up and ensure the solution we provided addressed your issue. If you require any further assistance or have additional questions, please let us know.

Your feedback is valuable to us, and we look forward to hearing from you soon.

 

Thanks..

Hi ybarsabal ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.