PowerBI Report now requiring Premium Capacity

[shaik_moh]

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.

[pvuppala]

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?

[acurwood]

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 · Accepted solution]

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.

[acurwood]

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.

[shaik_moh]

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

[GilbertQ]

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.

[shaik_moh]

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.

[GilbertQ]

Hi @shaik_moh 

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

[shaik_moh]

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,

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

[ZIre]

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]

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?

[jressing]

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

[ZIre]

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.

[ATZoeTang]

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

[acurwood]

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

[acurwood]

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.

[orbe]

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