Forum Discussion
Helper IVCSV data source missing columns depending on how it is imported
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
Helper IVHi danextian , I am actually not combining multiple files I am using a single CSV file.
I couldn't find the steps you meant unfortunately as I only have source when importing:
And the query just looks like this:
Super UserYou are trying to directly connecting to a CSV file in sharepoint? The Columns parameter determines the number of columns the connection is going to try to parse but it is actually optional so you can remove this part: Columns=15,
= Csv.Document(File.Contents("path\file.csv"),[Delimiter=",", Columns=15, Encoding=1252, QuoteStyle=QuoteStyle.Csv])
- PowerAutomater
The formula for me looks like this:
= SharePoint.Files("https://sharepoint.folder.path/", [ApiVersion = 15])
There isn't a column parameter. And if I click on the choose columns button, there is the same limited number of columns listed, it's like it's not getting fully imported or something.- danextian
That is a SharePoint folder connection and doesn't directly connect to a file stored in sharepoint. Use the full path to the file and the web connector instead of that.
Use the path only up to the extension in case there is an extra text string.