Forum Discussion
PowerAutomater
Helper IV
1 year agoCSV data source missing columns depending on how it is imported
When I use the the Text/CSV import option of "Get Data" all of the columns from my local CSV file come through and are avilable to use for visualisations. If I then upload the same CSV file to sharep...
- 1 year ago
Worked it out. I needed to choose transform data instead of load, then click on Binary in the first column. This video goes through it: How to connect to a data file in a SharePoint folder in Power BI
PowerAutomater
Helper IV
1 year agoWorked it out. I needed to choose transform data instead of load, then click on Binary in the first column. This video goes through it: How to connect to a data file in a SharePoint folder in Power BI