web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow Action 'Export To...
Power Automate
Unanswered

Flow Action 'Export To File for Paginated Reports' failing suddenly > error "Effective identity on datasources with SSO enabled is not supported"

(2) ShareShare
ReportReport
Posted on by 15

Hi all,

 

two of my flows are suddenly failing since saturday, there have been no changes from my end. The action that exports a file from paginated report (PBI premium per user) throws the error "Effective identity on datasources with SSO enabled is not supported". The two flows affected are supposed to export the files to a SFTP server in the following step.

All other flows exporting paginated reports from the same instance work perfectly fine. The only difference in setup is that the following action is Send to user per Mail instead of Create file on SFTP.

 

The error message implies that there might be an issue with my PBI connection, but many flows using the same connection work well. I have also set up a simple flow only with the export action. The two reports in question won't work (error hits immediately), all others will.

Any ideas?

 

Here's detailed error info:

{
    "statusCode"400,
    "headers": {
        "Pragma""no-cache",
        "Strict-Transport-Security""max-age=31536000; includeSubDomains",
        "X-Frame-Options""deny",
        "X-Content-Type-Options""nosniff",
        "RequestId""f012062f-fef6-45b3-9d8e-280e996ca66e",
        "Access-Control-Expose-Headers""RequestId",
        "Timing-Allow-Origin""*",
        "x-ms-apihub-cached-response""false",
        "x-ms-apihub-obo""true",
        "Cache-Control""no-store, must-revalidate, no-cache",
        "Date""Mon, 31 Jan 2022 08:14:47 GMT",
        "Content-Length""140",
        "Content-Type""application/json"
    },
    "body": {
        "error": {
            "code""InvalidRequest",
            "message""Effective identity on datasources with SSO enabled is not supported"
        }
    }
}

 

Many thanks in advance,

Kathrin

Categories:
I have the same question (0)
  • Community Power Platform Member Profile Picture
    on at

    I'm having the same issue:
    "Effective identity on datasources with SSO enabled is not supported"  
    With the flow failing from Jan 28th... Any ideas on how to solve this will be much appreciated. 

  • ElaineCRO Profile Picture
    4 on at

    I also started getting the same error since Jan 28.

    The error happened due to a connection failure with my Azure SQL Server. No onde changed any settings, so i believe there was some internal update in Azure.

     

    To solve it, i released the power automate IPs in my SQL Server firewall and now the flows are running correctly.

     

    Get the IPs in the link https://docs.microsoft.com/pt-br/power-automate/ip-address-configuration 

  • darlizzzz Profile Picture
    8 on at

    same problem

  • rk2221 Profile Picture
    3 on at

    Same issue, do we have any solution for this issue.

  • kmankash55 Profile Picture
    46 on at

    We are seeing the same issue at our company recently as well. We have a flow from Jan 18th failing with this error. 

     

    Getting the error: Flow Action 'Export To File for Paginated Reports' failing suddenly > error "Effective identity on datasources with SSO enabled is not supported"

    This is the Power BI action that we use.

    kmankash55_0-1643656133001.png

    @v-jefferni has anything changed with these Power BI actions?

  • j500sut Profile Picture
    18 on at

    I'm having the same issue with exporting a paginated report using the REST API Export To in Group.

     

    I have tested with a "normal" Power BI report and the export works just fine, so it seems to be only isolated to Pagenated reports.

     

    It would be good to have this resolved quickly as its a critical process for my client.

  • KaySunset Profile Picture
    15 on at

    My datasource is an analysis service tabular model, on which no firewall is enabled. Therefore, this solution will unfortunately not work for me..

  • jagdish0909 Profile Picture
    12 on at

    I am also facing same issue. It would be good if Microsoft share some solution quickly because many users are impacted and not able to delivered the reports.  

  • j500sut Profile Picture
    18 on at

    Hi all! 

     

    I managed to resolve the issue by opening the report in the service in Power BI Report Builder, re-entering the datasource credentials and re-publishing (no other changes were made).

     

    I was informed that the user who published the report previously was using version 15.7.1740.1

     

    After the republish using version 15.7.1796.1 and everything works now. I tested the API call from postman before re-running the Logic App.

     

    Hope that helps!

  • Community Power Platform Member Profile Picture
    on at

    Hi.

     

    I am having same issues. I am using latest version of Report Builder.

    There are several weird behaviors detected:

     1 - If Paginated Report is published using Windows Credentials it works on the PBI portal but it fails on the Logic App with the SSO error: "Effective identity on datasources with SSO enabled is not supported"

     2 - If Paginated Report is published using "Do not use credentials" the Logic Apps returns a "Bad Gateway" error.

    Plus a weird behavior happens if you run the report on the portal it reverts back the connection from "Do not use credentials" to "Windows" Auth.

    3 - If we try to specify a particular identity on the connector we get error " Exporting a paginated report with an effective identity with datasets is not supported "

     

    Our paginated report dataset is connecting to a Power BI premium (XMLA) dataset using RLS.

     

    Any ideas what is happening?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 523 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 406 Moderator

#3
abm abm Profile Picture

abm abm 245 Most Valuable Professional

Last 30 days Overall leaderboard