Forum Discussion

jwb3d's avatar
jwb3d
Frequent Visitor
19 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
    17 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? 

tayloramy's avatar
tayloramy
Icon for Super User rankSuper User
17 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?