Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all!
First of all, I know this is maybe a rookie question but I am so new in power bi.
I need to create a dashboard with ServiceNow data, this data will generate a different CSV every week that will be stored in a sharepoint folder with an unique name every day.
I need to import several CSV´s that are inside this sharepoint folder, and the power bi automatically updated every week appending the new CSV´s with unique name to the CSV´s that are already in the power bi
Is there any easy way to achieve this? i am also lost about how to add multiple CSV´s from a sharepoint folder as the only thing i see is a table with the name binary and when i click on the double arrow i only take one of the files... so definitely i am doing something wrong
Thanks!!!
Solved! Go to Solution.
Hello @Anonymous ,
It sounds like you're doing things the correct way...
Either way i'll show you with some pictures: Navigate to the correct directory and then filter to make sure only the relevant files remain.
Press the double arrow.
Select which parameter you want to extract from each file.
This should give you the data from all of the files combined in the following manner:
Hope this helps,
J
@Anonymous
As far as I know. SharePoint folder is currently the only and best way of importing multiple files. You can read this article to check details of shaping the data in power query.
Best,
Paul
I published this blog post today on how to do the merge process. https://marqueeinsights.com/how-to-merge-multiple-excel-files-with-power-bi/ That might be helpful.
Also note, we have a Power BI commercial solution that works with ServiceNow directly, without the CSV downloads. Send me a direct message if this is potentially of interest.
Hope this helps!
--Treb, Power BI MVP
Hello @Anonymous ,
It sounds like you're doing things the correct way...
Either way i'll show you with some pictures: Navigate to the correct directory and then filter to make sure only the relevant files remain.
Press the double arrow.
Select which parameter you want to extract from each file.
This should give you the data from all of the files combined in the following manner:
Hope this helps,
J
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |