Forum Discussion

wac1ldy's avatar
wac1ldy
Frequent Visitor
5 years ago

Not Reading Data

Good day all. My PBI reads data from an Excel file that is fed by an Alteryx Workflow. The workflow simply pulls two Excel worksheets together, cleans them and outputs the results to a third Excel w...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi wac1ldy ,

 

Does your manual refresh also not work? (just click "refresh" in Power BI Desktop)

What data source did you choose in the figure below? I cannot find the "Alteryx Workflow".

 

 

Best Regards,

Yuna

  • wac1ldy's avatar
    wac1ldy
    Frequent Visitor
    5 years ago

    Yuna,

    I selected the Excel (top one).

    There is no auto refresh yet, strictly unpublished. When I manually refresh, it runs through the read process as normal but does not pick up the new data. I then manually open the Excel file and click in any cell and save the file and close it. I run the refresh again and it picks up the new data. But as soon as I run the next day's Alteryx, I am back to it not picking up the new data.

     

    Here is the Alteryx append piece:

    Thank

     

    CW