Forum Discussion

ed7's avatar
ed7
Icon for Microsoft Employee rankMicrosoft Employee
6 years ago
Solved

Import all (including recently added columns) from CSV file at refresh

I imported time series CSV file with 64 columns. Every day there is a new column added to the file. But when I refresh it is not imported.. I checked the query and PBI explicitly put 64 columns when ...
Need Help
  • edhans's avatar
    edhans
    6 years ago

    The Columns parameter is optional. Just get rid of it. Because they are labeled as they are in the SOURCE line, you don't need to leave a space for it with an empty comma.

     

    Source = Csv.Document(Web.Contents("LINK"),[Delimiter=",", Columns=64, Encoding=65001, QuoteStyle=QuoteStyle.None])

    becomes

    Source = Csv.Document(Web.Contents("LINK"),[Delimiter=",", Encoding=65001, QuoteStyle=QuoteStyle.None])

     

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
6 years ago

The Columns parameter is optional. Just get rid of it. Because they are labeled as they are in the SOURCE line, you don't need to leave a space for it with an empty comma.

 

Source = Csv.Document(Web.Contents("LINK"),[Delimiter=",", Columns=64, Encoding=65001, QuoteStyle=QuoteStyle.None])

becomes

Source = Csv.Document(Web.Contents("LINK"),[Delimiter=",", Encoding=65001, QuoteStyle=QuoteStyle.None])

 

FOliveira's avatar
FOliveira
Frequent Visitor
1 year ago

Hello I have the same problem in a file stored in a sharepoint site:

 

= Csv.Document(Web.Contents("https://sonepar.sharepoint.com/sites/O365SoneparglobalITteam-NEWLicenseControlInformation/Documents%20partages/NEW%20License%20Control%20Information/Assigned%20licenses/AzureAD_Users.csv"),[Delimiter=",", Encoding=1252, QuoteStyle=QuoteStyle.None])

 

and I get this error:

DataSource.Error: Web.Contents failed to get contents from 'https://sonepar.sharepoint.com/sites/O365SoneparglobalITteam-NEWLicenseControlInformation/_api/web/getfilebyserverrelativeurl('/sites/O365SoneparglobalITteam-NEWLicenseControlInformation/Documents%20partages/NEW%20License%20Control%20Information/Assigned%20licenses/AzureAD_Users.csv')/$value' (404): Not Found
Details:
DataSourceKind=Web
DataSourcePath=https://sonepar.sharepoint.com/sites/O365SoneparglobalITteam-NEWLicenseControlInformation/Documents%20partages/NEW%20License%20Control%20Information/Assigned%20licenses/AzureAD_Users.csv
Url=https://sonepar.sharepoint.com/sites/O365SoneparglobalITteam-NEWLicenseControlInformation/_api/web/getfilebyserverrelativeurl('/sites/O365SoneparglobalITteam-NEWLicenseControlInformation/Documents%20partages/NEW%20License%20Control%20Information/Assigned%20licenses/AzureAD_Users.csv')/$value