cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

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.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors