Upload functionality for Power BI

[raveenaMathkar]

Hi,

I have a csv file conatining 4 columns and it is processed using snowflake query and then machine learning predictions are done on that. After machine learning predictions we get 7 columns in which 2 are predicated columns and rest of the columns are fetched from snowflake table using 4 columns from the csv file and then i get anothet csv file which containes 7 columns.

So, currently i am visualizing data over these 7 columns in Power BI using file which contains 7 columns which i downloaded using python code.

But i want to automate this process like the user will upload file and it will hit snowflake table fetch the stored data from there including the predicted columns, get the required data to visualize into Power BI desktop.

How can I implement this fetaure?

[VijayP]

@raveenaMathkar 

You can use Power Automate to get this data upated as per your requirement, hope this link may help you!

https://www.cdata.com/kb/tech/snowflake-odbc-power-automate.rst