Forum Discussion

BEC_100's avatar
BEC_100
Frequent Visitor
2 years ago
Solved

Access report via Embeded

I have been using a cloud service (classic) to access a report.  I have embeded link via <iFrame> to access a report as follows:

<div>

 

    <iframe title="MyReport" width="1540" height="941" src="https://app.powerbi.com/reportEmbed?reportId=facaa230-08e3-4408-b0ab-0a61171da14d&autoAuth=true&ctid=5dbf1add-202a-4b8d-815b-bf0fb024e033" frameborder="0" allowFullScreen="true"></iframe>

</div>

 

Recently azure upgraded to use Cloud service (extended support) because the classi will be deprecated.

Now when I click on the link, I am asked for credentials (as before) but it keeps recclyng. Asking for credentials over and over.

I have ensured the latest embeded code is correct.

 

If I go directly to https://app.powerbi.com/ and enter the credentials, the reports work fine.

Do not want to provide direct access to reports because the Azure service contains other applications suitable for the end-user.

Has anyome encounter similar behavior?

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, BEC_100 

    You can troubleshoot the problem from the following aspects:
    1. Check the embed code. You mentioned that you made sure the latest embed code was correct. Check the following carefully:
    - The report ID in the 'src' attribute of '<iframe>' matches the correct Power BI report.
    - Correctly set the "autoAuth=true" parameter to enable automatic authentication.
    - The `ctid` parameter (if used) corresponds to the correct tenant ID
    2.Authentication Flow. Make sure the report is configured to use the same authentication method as before (such as Azure AD, service principal, or direct query). The credentials provided in the embed code match the authentication method configured for the report
    3.Azure cloud service (extended support) may have different behavior compared to the classic version. For more details about Azure cloud services (extended support), you can click on the link below:
    https://learn.microsoft.com/en-us/azure/cloud-services-extended-support/faq

    4. Certificate keystore. If your reports rely on certificates, consider using Azure Key Vault: Add the certificate to Key Vault, referencing the certificate thumbprint in the service configuration file.
    Ensure that the Cloud Service (Extended Support) resource has the appropriate permissions to retrieve the certificate stored as a secret from the Key Vault.
    You can try the following two methods:
    1. Use service principal. In the extended support version, you may need to use Service Principal for authentication. This means you need to create a service principal in Azure Active Directory and use its credentials to authenticate embedded Power BI reports.
    2. Use Azure AD integration. If your environment supports Azure AD integration, you can configure single sign-on (SSO) so that after users log in for the first time, their credentials are remembered and they do not need to be entered each time.

     

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

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

3 Replies

  • aj1973's avatar
    aj1973
    Community Champion

    Hi BEC_100 

    Did you check with Power BI admin of the portal? the embed code might have been disabled by default.

     

  • You may want to obfuscate/remove your ctid when you post to public forums.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi, BEC_100 

    You can troubleshoot the problem from the following aspects:
    1. Check the embed code. You mentioned that you made sure the latest embed code was correct. Check the following carefully:
    - The report ID in the 'src' attribute of '<iframe>' matches the correct Power BI report.
    - Correctly set the "autoAuth=true" parameter to enable automatic authentication.
    - The `ctid` parameter (if used) corresponds to the correct tenant ID
    2.Authentication Flow. Make sure the report is configured to use the same authentication method as before (such as Azure AD, service principal, or direct query). The credentials provided in the embed code match the authentication method configured for the report
    3.Azure cloud service (extended support) may have different behavior compared to the classic version. For more details about Azure cloud services (extended support), you can click on the link below:
    https://learn.microsoft.com/en-us/azure/cloud-services-extended-support/faq

    4. Certificate keystore. If your reports rely on certificates, consider using Azure Key Vault: Add the certificate to Key Vault, referencing the certificate thumbprint in the service configuration file.
    Ensure that the Cloud Service (Extended Support) resource has the appropriate permissions to retrieve the certificate stored as a secret from the Key Vault.
    You can try the following two methods:
    1. Use service principal. In the extended support version, you may need to use Service Principal for authentication. This means you need to create a service principal in Azure Active Directory and use its credentials to authenticate embedded Power BI reports.
    2. Use Azure AD integration. If your environment supports Azure AD integration, you can configure single sign-on (SSO) so that after users log in for the first time, their credentials are remembered and they do not need to be entered each time.

     

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

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