Forum Discussion
Publish to web
- 2 years ago
RLS is not allowed when you do Publish To web. Consider that RLS is a security rule for the logged account. It wouldn't make sense for a public url that anyone without an account can see.
I hope that make sense
- 2 years ago
It is very likely that the feature was turned off at the tenant level to prevent people from accidentally/intentionally publishing private data to the public web. This feature is very commonly disabled. You might work with your IT team to see if they will allow it for specific users.
I have a MS form that is submitted and triggers a Power Automate Flow. The answers are put in an excel (on MS Teams or Sharepoint if that is the same?). This excel makes up the dataset of a power BI report. Everytime someone submits the form, the excel should be updated, the dataset refreshed the report (on the public web) refreshed and the report be exported as a PowerPoint file to a folder in the same Teams group the excel and form are in. Do you see any trouble in that?
- ibarrau2 years ago
Super User
The form filling new rows for an excel with Power Automate is correct. Regarding the dataset it's not that straight forward because the refresh of the dataset is asyncronous. You can only trigger a refresh 8 times a day, so you must think the time you want to configure the refreshes and it's not going to be real time.
The automatic export to PowerPoint can only be done with the Power Bi Rest API if you purchase a capacity license like Premium.
I hope that helps,