Results 1 to 1 of 1

Thread: Can PowerBI refresh the PowerQuery on my Excel data
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Dec 2004
    Posts
    663
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Can PowerBI refresh the PowerQuery on my Excel data

    I have PowerBI connected to Excel data source (ie not imported but "linked").
    This Excel (either can be on OneDrive business or desktop) contains a powerquery to do data transformation.

    The data in Excel data itself is stored in "Data" tab that resides within this Excel and does not further get data externally.

    The PowerBI get data from another tab which is a "Result" table of the powerquery in this Excel.

    From time to time system would make changes to "Data" tab. There is a need to refresh the Excel's powerquery to update "Result".

    My challenge here is, is it possible the PowerBI (desktop or web BI Service) to refresh the Excel's powerquery & the Result table and sync new result into Power BI ?
    How ? Please help. Thanks.

    And if PowerBI cannot do this, is there any way to refresh Excel powerquery for Power BI's consumption ?
    I know moving Powerquery into PowerBI is one way, but if possible due to business nature we wish not to do so ...

    Pls help.. thanks all...
    Last edited by mrchonginhk; May 18th, 2019 at 08:49 PM.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •