Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
ania_roh
Helper III
Helper III

Doubt with geting data from excel

Hello,

I'm preparing myself for the certification PL300 and I have a doubt regarding to the information I found in the documentation :

ania_roh_0-1709300197818.png

1. If we get data from local excel file, I undersand that changes to the original excel ARE REFLECTED in Powerbi after refreshing Powerbi. So I don´t undersand why it says that we should use it for data that doesn´t change. If we put updating data in service every hour, it will update it. 

 

2. If we get data from excel of onedrive, it says that reports are automatically updated. 
I created a powerbi report with data loaded from WEB -> onedrive ( I put my URL there). 
Then I published that in service ( the same account in Onedrive as in Powerbi), I changed data in excel in onedrive, and my data doens´t change automatically in Powerbi.
I have to put " refresh" in Powerbi to see data changed. 

The documention says that OneDrive and Powerbi connect to each other about once an hour. 
so I it refreshes it automatically. 

So, why if it is automatic, why do I need to refresh PowerBi ?

 

ania_roh_1-1709300789259.png

 

I don´t get what the documention says. 
Can you please help me to understand that?

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

@ania_roh Correct, the documentation for the local file is not accounting for if you are running a data gateway and refreshing the data. And, I have never had any luck with the the whole "automatic" update between Power BI and OneDrive for Business. As far as I am concerned, that functionality has never actually worked correctly. At least not for me.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

@ania_roh Correct, the documentation for the local file is not accounting for if you are running a data gateway and refreshing the data. And, I have never had any luck with the the whole "automatic" update between Power BI and OneDrive for Business. As far as I am concerned, that functionality has never actually worked correctly. At least not for me.


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.