Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id : Hu9LXQte5mYi97m1pY/EGt
Power Platform Community / Forums / Power Automate - Building Flows / Power query cant read ...
Power Automate - Building Flows
Unanswered

Power query cant read from group SharePoint documents if file put there by Power automate

Like (0) ShareShare
ReportReport
Posted on 6 Oct 2020 15:40:55 by Community Power Pla...

Hi all,

I have manged to create a Power BI query that pulls data from a spreadsheet on the Group SharePoint - shared documents library.

I also created a Power Automate to save the spreadsheet to the SharePoint when it arrives via email (arriving in a group mailbox in Outlook).

 

The issue is that the Power query in Power BI can pull the data from the spreadsheets on the SharePoint only when they are put there via a file upload or dragged and dropped from desktop or email.

If the file is placed on the SharePoint by the Power Automate flow the Power BI query says:

"DataFormat.Error: File contains corrupted data.
Details:
[Binary]"

 

Can anyone help to understand what the difference is between a file saved there by the Power Automate or my me?

 

Flow details:

When a new email arrives in a shared mailbox (V2): "Original Mailbox Address" & "Subject Filter"
Apply to each: "Select an output from previous steps" : Attachments (Outlook)
(Sharepoint) Create File: "Site Address"; "Folder Path"; "File Name"; "File Content"

 

Thanks,

  • TA-15101348-0 Profile Picture
    TA-15101348-0 6 on 11 Dec 2024 at 14:48:12
    Power query cant read from group SharePoint documents if file put there by Power automate
    did you ever got an answer here? Im having the same issue
  • Community Power Platform Member Profile Picture
    Community Power Pla... on 08 Oct 2020 at 16:35:07
    Re: Power query cant read from group SharePoint documents if file put there by Power automate

    Hi Javier

    Yes its saving as an .XLSX

    Type

    XLSX File

    Also curiously the file cant "preview" in SharePoint when deposited in library by the flow.

     

    Thanks,

  • Javier Gallego Profile Picture
    Javier Gallego on 08 Oct 2020 at 13:59:26
    Re: Power query cant read from group SharePoint documents if file put there by Power automate

    Hi LeeScape,

     

    In what format are you saving the file? .XLSX

     

    Thanks.

    Javier

     

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

News and Announcements

Welcome to the Power Platform Communities
Announcing our 2025 Season 2 Super Users!

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans