cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
shahar26 Frequent Visitor
Frequent Visitor

PowerBI desktop using Excel files

Dear community ,

i am using powerBI in the last few months and really love it.

 

but i have some understanding questions and some problems that i wandered if someone could help me with.

 

1. my data sources unfortunatlly are excel files at the moment . but i use around 10 files with a lot of data for 1 report , i was wandering if there is a better way to do this process meaning would it be better to create an Acess DB based from those files and connect it to powerBI , or is it just a waste of time. my understanding problem is - lets say i have new data and i inserted it in my excel files (copy paste of the data into the excel file ) now if i will refreash the report on my powerBI will the data be changed too ?

 

2. if i use excel files as my data source and then send the powerbi report to someone that dont have access to my drive where the files are - will he be able to see my files ? and if i will update my report , will it be updated for him as well ?

 

3. is there a powerBI training i can participate - not the videos?

 

Thank you for your help

Shahar

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: PowerBI desktop using Excel files

@shahar26,

 

Basically, it won't make a big difference. As for the data refresh, take a good look at this link.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: PowerBI desktop using Excel files

@shahar26,

 

Basically, it won't make a big difference. As for the data refresh, take a good look at this link.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors