Skip to main content

    Power BI

    Needs Votes

    Data flow with xlsm files

    Vote (22) Share
    Lars Paulsson's profile image

    Lars Paulsson on 30 Apr 2021 07:37:10

    I need data flow, using xlsm files - why isn't this option available? (only xlsx files)
    Is there a plan to include these files to create data flows?

    Comments (2)
    Lars Paulsson's profile image Profile Picture

    GUILLAUME LEBRUN on 07 Dec 2022 13:32:03

    RE: Data flow with xlsm files

    Hello, We have a "all in one" Excel file that work like a relational database (different tabs, a key to match main tab and the others) and of course the first tab is an overview with macro. It's impossible to get data from this XLSM file using "sharepoint folder connector" within PowerBI Desktop or the browser version....

    Lars Paulsson's profile image Profile Picture

    Michael Young on 15 Jul 2021 09:46:48

    RE: Data flow with xlsm files

    Hi Lars, I may have a workaround for you if you're still struggling with this.

    Michael