Categories
Power Apps Power Automate Power BI

Data types of rollup vs calculated vs Power Fx in Power Apps

The following is the comparison of data type supported by the rollup, calculated and Power Fx in Power Apps

RollupCalculatedPower Fx
Single line of textSingle line of text
Choice
Yes/noYes/no
Whole numberWhole Number
Decimal numberDecimal NumberDecimal number
CurrencyCurrency
Date and timeDate and timeDate and time

Source:

Categories
Power Apps Power Automate Power BI

Power Platform – Restore

The following is an excerpt on restoring Power Platform environments

To restore to a production environment, you must first change its type to sandbox.

Administration mode

You can set a sandbox, production, or trial (subscription-based) environment in administration mode so that only users with System Administrator or System Customizer security roles are able to sign in to that environment.

Administration mode is useful when you want to make operational changes and not have regular users affect your work, and not have your work affect end users (non-admins).

You can optionally disable background operations such as all asynchronous operations including Dataverse workflows and email server-side synchronization.

Source: Environment operations – Training | Microsoft Learn

Categories
Power Apps Power Automate Power BI

Power Platform – Backups

The following is an excerpt regarding the backups of Power Platform.

System backups

System backups occur continuously and aren’t counted towards capacity.

If you use Microsoft Power Platform to create production environments that have a database and Dynamics 365 applications enabled, you can benefit from the system backups that are automatically performed for those environments. The system backups are stored for up to 28 days.

For environments that don’t have Dynamics 365 applications enabled, the default backup retention period is only seven days. However, for managed environments, admins can use PowerShell to change the setting and extend the backup retention period. The available options are 7, 14, 21, and 28 days.

All environments, except Trial environments are backed up.

Manual backups

Automated system backups are great, but you should make your own backups before making significant customizations or applying a version update.

About manual backups:

  • A backup is created for you when Microsoft updates your environment.
  • You can back up production and sandbox environments.
  • You can back up developer environments.
  • You can’t back up the default environment.
  • Sandbox backups are retained for up to seven days.
  • Developer backups are retained for up to seven days.
  • Manual backups for production environments that are created with Dataverse and Dynamics 365 applications enabled are retained up to 28 days.

Source: Environment operations – Training | Microsoft Learn

Categories
Power BI

Power BI – Error – Contact your admin to enable embed code creation

Microsoft Power BI When a user tries to create new embed codes using the “Publish to Web” feature, he/she/them will get the error “Contact your admin to enable embed code creation”.

Cause of the error

The reason behind this issue is, Microsoft changed the default state of “Publish to web” setting in tenant admin settings. Previously it used to be “Allow existing and new codes” and now it’s “Only allow existing codes”

The fix

The fix is simple, just change the settings to “Allow existing and new codes” and users should be able to publish to web.

The security issue & fix

But wait still the security issue exists. Any user can publish to the web and the report data is exposed to any user on the Internet who has access to the report URL. So the best course of action is to enable the additional security settings, which is “Apply to” “Specific security groups”. Once enabled, only users from a specific security group will be able to create embed codes using “Publish to web”.

For more documentation on the settings, please visit Microsoft Docs