Power BI Exchange

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

View My Drafts

Back to discussions
Expand all | Collapse all

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
    ------------------------------