Forum Discussion
feed visuals and tables based on different CSV files
OneDrive is basically SharePoint so that's a good start. Just bear in mind, for a more robust solution, having it on an actual SharePoint site would be better, e.g. not your personal OneDrive, you may run into sharing issues.
The first issue is, you're referring to an individual file.
The next is, you're using the local reference to the OneDrive folder, which won't refresh without a gateway once it is published to the service.
We can fix both of these at once.
Whether you use OneDrive or SharePoint the step will be the same.
Your Source step will be something like...
SharePoint.Files("https://yourdomain-my.sharepoint.com/personal/your_name_your_domain", [ApiVersion=15])or if SharePoint...
SharePoint.Files("https://yourdomain.sharepoint.com/sites/your_site_name", [ApiVersion=15])You should then get a list of files on the site.
Next step, filter to only show the ones you want, this is usually done by folder/file type etc.
Once you've done that and you're happy you're only showing the files you want to combine, click the combine button and watch the magic start to happen.
Any common transforms you need to do, i.e. changes you want done to all files, get done in the 'Transform Sample File' step. This then replicates to all the files automatically.
There are other tips and more concise ways to do it but they are more advanced. I think this is a good starting point.
Super UserTo answer your questions.
- Yes it can.
- All in same table.
Questions.
- Where are the CSV files stored? (cloud/sharepoint or on-prem)
- What is your 'Source' step currently?
You'll need to use either SharePoint.Files() or Folder.Files() (with a gateway) and then choose to combine the files.
Hi KNP ,
Thanks for your prompt reply. Answering your questions:
1. One Drive Location in my laptop. But I can move it to Sharepoint if needed.
2. The Source step is:
= Csv.Document(File.Contents("C:\Users\AndresHernandez\OneDrive\Ran Configuration\Projects\RAN Optimization\Power BI Report\CPE throughput and QOS 2022-11-14 18_09.csv"),[Delimiter=",", Columns=20, Encoding=1252, QuoteStyle=QuoteStyle.None])
Could you give some instructions on how to do it?
- KNP
OneDrive is basically SharePoint so that's a good start. Just bear in mind, for a more robust solution, having it on an actual SharePoint site would be better, e.g. not your personal OneDrive, you may run into sharing issues.
The first issue is, you're referring to an individual file.
The next is, you're using the local reference to the OneDrive folder, which won't refresh without a gateway once it is published to the service.
We can fix both of these at once.
Whether you use OneDrive or SharePoint the step will be the same.
Your Source step will be something like...
SharePoint.Files("https://yourdomain-my.sharepoint.com/personal/your_name_your_domain", [ApiVersion=15])or if SharePoint...
SharePoint.Files("https://yourdomain.sharepoint.com/sites/your_site_name", [ApiVersion=15])You should then get a list of files on the site.
Next step, filter to only show the ones you want, this is usually done by folder/file type etc.
Once you've done that and you're happy you're only showing the files you want to combine, click the combine button and watch the magic start to happen.
Any common transforms you need to do, i.e. changes you want done to all files, get done in the 'Transform Sample File' step. This then replicates to all the files automatically.
There are other tips and more concise ways to do it but they are more advanced. I think this is a good starting point.
