Publish to web for some reports doesn't work

[v_franz]

Hello,

I have a Report and I tried to Publish on Web, but for some it doesn't work. It simply doesn't show the option:

For others it works fine. Does anybody have an idea how to fix it?

Here you can see thee option: publish to web (public).

P.S: If I copy the whole content in the already published one, it works fine.

Thank you

Viktor

[v_franz]

I did check it, no RLS and no ROLES in general. I'm using exaclty the same dataset for all the reports (so some are working and others not)

[v_franz · Accepted solution]

I finally found the problem:

In order for a sheet to be published on the web, no additional measures may be created in the dataset! (if you have a live connection).

[v-xinruzhu-msft]

Hi @v_franz 

Please check the following points:

1.Did they have the related license, need a Microsoft Power BI license to publish to web from My Workspace/group workspaces

2.the function is not available for shared report

3.if the reports in a workspace in which you aren't an edit member, you cannot use the function.

You can refer to the following link.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web#prerequisites

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web#considerations-a...

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v_franz]

Thank you for your quick reply.

1) yes they have a license (it works for other sheets without any problems)

2) it's not a shared report (it's a new one)

3) I'm a member that can edit everything.

It's really weird, I don't have an idea, how to fix it somehow.

I tried almost everything already.

[v-xinruzhu-msft]

Hi @v_franz 

Did the report has the RLS, if the report has RLS, It canot publish to web.

Please see the limitations below:

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-publish-to-web#considerations-a...

Best Regards!

Yolo Zhu

[v_franz]

How can I check this? RLS (Row Level Security)

If I want to change any settings the settings are grey:

[v-xinruzhu-msft]

Hi @v_franz 

You can check it in Security of dataset, check if it exist Role.

If it displays the following , it has not RLS, if it has a role, it contains a RLS

Best Regards!

Yolo Zhu