Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I'm looking for a quick and easy way to generate raw data into useful metrics for my employer. For various reasons, I'm unable to sufficently test Power Bi myself, so I'm having a difficult time figuring out if it's the right application that will allow me to:
Currently, I manually prepare reports in Excel using 3+ datasets. A lot of time is spent preparing the data with VLOOKUPs and IF formulas, creating Pivot tables and then manually updating a dashboard with new monthly numbers.
If I could simply upload the .CSVs into Power BI and let it do 99% of the work, that would be my best-case scenario. Is this realistic, or will I still need to do a lot of the manual work?
Solved! Go to Solution.
Yes it can. As always the devil is in the details, but on a whole it can do exactly that.
One way you could do exactly how you were describing is to have a shared folder that hosts the CSV files. Users copy their data over the top and go into their Power BI file (either desktop or web service). They then tell their Power BI to refresh and it will grab the latest data and refresh the reports.
Yes it can. As always the devil is in the details, but on a whole it can do exactly that.
One way you could do exactly how you were describing is to have a shared folder that hosts the CSV files. Users copy their data over the top and go into their Power BI file (either desktop or web service). They then tell their Power BI to refresh and it will grab the latest data and refresh the reports.
Can Power BI update dashboard from files that were uploaded onto a shared Network drive, or does it specifically have to be on something like SharePoint Online.
Yep works great. All you need to do is make sure that the username you supplied to the gateway has access and that the filepath is the same in both your desktop file and in the gateway. For example, don't use "C:\Folder\File.xlsx" you would use "\\Computer\Folder\File.xlsx"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.