Forum Discussion

Brianii's avatar
Brianii
Frequent Visitor
2 years ago

Is there a better solution to pulling data from CSV files located on SharePoint ?

I have data extractions in .CSV format saved to a SharePoint folder. Dataflows pull the data from the SharePoint folder and perform transformations. PowerBi then connects to dataflows, adds some DAX ...
Dataflow
Need Help
Brianii's avatar
Brianii
Frequent Visitor
2 years ago

1. I do all the heavy lifting in Power M, and use Dax for small things. Is it possible to use the actual Dax in Dataflows? 

2.  Could you elaborate on what do you mean by directly linking to CSVs? In the current set up all extractions are automiatically saved in a SharePoint folder and then Dataflows feed from the folder.

collinq's avatar
collinq
Super User
2 years ago

Hey Brianii ,

 

My apologies,  I misspoke.  I was thinking of complex M transformations and not DAX.  

 

As for the csv files I was wondering about you having a place other than sharepoint (like onedrive or s network share) to remove one more step.