Forum Discussion

jwb3d's avatar
jwb3d
Frequent Visitor
23 days ago
Solved

Update visual table column via CSV

I want to incorporate the values from the CSV file into the Key columns specified in the visual table. I have created a CSV file named "BI-Del.csv". Upon clicking a button, I would like to read the ...
admin
  • tayloramy's avatar
    tayloramy
    21 days ago

    Hi jwb3d​,

    Can you elaborate more on the desired functionality? 

    I assume this is in a Power BI report? 

    If you want a button click to load data into a report, then you're looking at a translytical task flow. 
    Understand translytical task flows - Power BI | Microsoft Learn

    This allows pressing the button to call a python UDF in Fabric, which can then load data. 

    Can you explain how your model is currently set up? Translytical task flows work best with DirectLaake models where the data is sitting in a warehouse. 

    Can you also explain where this CSV file is? Is it sitting in an on prem file share, is it in sharepoint, or is it in a lakehouse file section already? 

v-csrikanth's avatar
v-csrikanth
Icon for Community Support rankCommunity Support
19 days ago

Hi jwb3d​ 

We would like to inquire whether have you got the chance to check the solutions provided by ShivekMaharaj​ tayloramy​  in community to resolve the issue. We hope the information provided helps to clear the query. Should you have any further queries, kindly feel free to contact the Microsoft Fabric community.