Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only

Mix of Data Automation & Manual Configuration

  • 1.  Mix of Data Automation & Manual Configuration

    Posted Dec 08, 2022 05:23 AM
    Edited by Gulfam Ahmad Dec 08, 2022 05:26 AM
    I have connected my live report with a dataset available online and put it on scheduled refresh. One of the columns in dataset must be tagged by our finance guy, what we do is:

    • We export excel and put it in one-drive.
    • Finance guy tags the entries.
    • Then we import this one-drive excel file into Power BI
    • and add the new tagged column at the end of live data using DAX (Lookup)
    • We have to do the excel export every week or two weeks to update this one column.

    Please guide me, is there a way that i can automate this one step as well?

    Thank you for your help.

    ------------------------------
    Gulfam Ahmad
    Head of Analytics
    ------------------------------