Share PowerBI dataset to external user

From any existing user has PowerBI Pro license, you can share the reports to user who don’t have it => your shared user will be in your tenant AD, and will be logged on as external user.

  1. Share the dataset ManagePermissionOnDataset
  2. Make sure the Non – Pro Power BI user is hereDatasetShared.png
  3. Copy the report link from a reportReportLink
  4. Logon to the shared user and browse to the link above, will be a dialog to “Try Pro for free”TryProForFree.png
  5. Yeah, just try itStartTrial.png
  6. CongratulationCongratulation.png
  7. Check again on your Power BI serviceMakeSure.png

Wildcard SSL for SP and high-trust-certificate

NOTE: The certificate forĀ  high trust does not support CNG enabled. Have to create with a legacy option.

I. Follow this to create a new certificate using for SSL:

https://support.jetglobal.com/hc/en-us/articles/235636308-How-To-Create-a-SHA-256-Self-Signed-Certificate

Example:

$cert = New-SelfSignedCertificate -DnsName “*.spdev.com” -CertStoreLocation “cert:\LocalMachine\My”

Then, go to iss web application -> bindings -> edit -> https -> SSL certificate: *.spdev.com -> host name: http://www.spdev.com -> port 443

launch the web application, on address bar, click to install the certificate to the computer

II. Follow this to create a new certificate for SP high trusted app:

https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/create-high-trust-sharepoint-add-ins

Example:

  1. Create a self-sign-certificate
  2. Export to pfx
  3. Export to cer
  4. Open MMC, install certificate to “Trusted Root Certificate Authority” and “Personal”
  5. On Personal, right click to the certificate -> All Tasks -> Manage Private Keys…-> Add user in your wep application pool to here
  6. Share certificate folder to everyone
  7. ……………………
  8. New-SPTrustedRootAuthority (remove first if already existed)
  9. New-SPTrustedSecurityTokenIssuer (remove first if already existed)
  10. AllowOAuthOverHttp
  11. Update OnPrem.config for all web applications
  12. IIS reset all