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, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
shaik_moh
Microsoft Employee
Microsoft Employee

PowerBI Report now requiring Premium Capacity

In a workspace that has the 'Pro' License mode, a report was previously enabled and visible, both in the PowerBI portal as well as when embedded. However, it is no longer enabled, and when accessed via the portal, shows the error, 
" Power BI Premium is required

The dataset for this report is backed by premium files storage and can only be loaded on a Premium capacity. Go to Workspace settings and move the workspace to a Premium capacity to re-enable the report."

My question regarding the same are:

  • What are the reasons for this breaking change? (The semantic model only has connection Azure Data Explorer)
  • What is the impact of changing to a Premium Capacity for the workspace? On basis of my investigation, all previous users who could view the reports present in the workspace under the 'Pro' license would remain unaffected, and the above mentioned report would be re-enabled.
  • What changes can be made to enable the report if moving the workspace to Premium capacity is not an option.
1 ACCEPTED SOLUTION
shaik_moh
Microsoft Employee
Microsoft Employee

Hi @ZIre @acurwood , for my use case, I had to get rid of any resources that were Fabric resources (Such as Dataflow Gen2, Data Warehouse, etc.) and then change the license in my Workspace to Premium Per User. This got rid of the error. Alternatively, as a short term fix (Because Trial License is only for a limited period of time), we changed the License to Trial, and the reports started to work.
(Pro License does not support some datasets that are backed by Premium Capacities). I unfortunately do not have more to share with you, let me know if this helps.

View solution in original post

17 REPLIES 17
pvuppala
Helper IV
Helper IV

Hello, one of our customers are seeing this issue on a particular report, the data source being an excel file from onedrive.  Nothing changed on their end.  Did anyone resolve this issue?

Hello, yes the issue was triggered because of the end of the Fabric free trial period. If you delete the report from the reporting service and republish it under your normal licence, this should work again.

 

shaik_moh
Microsoft Employee
Microsoft Employee

Hi @ZIre @acurwood , for my use case, I had to get rid of any resources that were Fabric resources (Such as Dataflow Gen2, Data Warehouse, etc.) and then change the license in my Workspace to Premium Per User. This got rid of the error. Alternatively, as a short term fix (Because Trial License is only for a limited period of time), we changed the License to Trial, and the reports started to work.
(Pro License does not support some datasets that are backed by Premium Capacities). I unfortunately do not have more to share with you, let me know if this helps.

Hi @shaik_moh we have nothing in the file that is connected to any of the Fabric resource to my knowledge, nor any of Azure services. All connected to SQL server, so there should be no reason for the published report not to work. I will review if it is the admin account scheduled to refresh the report that is on the wrong licence.

 

Try to change the workspace license to Premium Per User, that fixed it for us.

GilbertQ
Super User
Super User

Hi @shaik_moh 

 

When you are using power bi embedded, this needs to be backed by a capacity. That is why it is no longer working because it appears to be that this is now being strictly enforced. You would need to purchase an Azure or EM an A SKU and assign that to your workspace to get it working again for Power BI embedded.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Would this also prevent viewing of the report in the PowerBI portal? I am facing this issue not only when embedding the report in question, but also in the portal.

Hi @shaik_moh 


Can you show the Workspace settings and see if it is still set to someting else?

 

GilbertQ_0-1713245106227.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

shaik_moh_0-1713252561567.png

The above is what is visible when I check workspace license info.

Additionally,

below is what error shows up when I attempt to view the report in the PowerBI Portal,

shaik_moh_1-1713252662924.png


Other reports are not facing the same issue, and I am able to view them when embedded and in the PowerBI portal.

I'm also facing the same issue. The report was viewable in PowerBI Portal two hours ago and suddenly showed this error message. We have another try to publish the same report in a different name and it is working. May I know if you have managed to resolve it?

acurwood
Frequent Visitor

Hi @shaik_moh I am also experiencing the same issue just this morning. I have changed nothing to do with how we publish reports to the reports service and this messaging is only showing on certain reports. Are there any moderators on this forum from Microsoft that can help us?

I face the same problem as of today. Does anyone already have a solution for this problem?

ZIre
Frequent Visitor

For those who are still struggling with this issue, the Power BI support identified a potential cause and solution. It is likely that when we turned on the (Fabric) Trial capacity, there is an option "Semantic model storage format". If we selected "Large semantic model storage format" and reports published in those workspaces will default to using that storage format - which requires premium capacity. Once the Trial is over, those reports are stayed in that storage format (check Semantic model > Settings).

 
You won't be able to modify the above settings after the trial.

 

The solution (as described by the support but I didn't try): switch the workspace to Trial, the above setting can be updated. Once updated, switch back to your original License tier.

ZIre_1-1721207162706.png

ZIre_0-1721206929376.png

Thanks for your help, I successfully set up the Large Semantic model storage format.
acurwood
Frequent Visitor

Hey, yes the solution was to delete the report from the reporting service and republish it after your Fabric trial has ended.

acurwood
Frequent Visitor

Thanks @ZIre . We dropped and republished the report as we identified that the Fabric licence was the only thing that had changed. What a hassle that is to push people to trial, change model settings and then allow now smooth transition/recommendation based on your licence type. Hopefully Microsoft with address this with future releases in their CX.

The problem started when I changed the workspace to Fablic's trial, when the trial ended the problem occurred.
The only solution that worked for me was to delete the report from the workspace and reload it

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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.