Mate, this video literally saved my job and mental health. I have been struggling to find the right solution to set auto refresh for months now and most of the videos I watched didn't really help. Your video is simple and straightforward. Answered all my queries. Thanks buddy, subscribed✌️
HALLELUJAH! Sir, this is the SINGLE most helpful tutorial I have found for autorefresh. I have struggled with this for a solid three months now battling with the gateways. THANK YOU!
So if I add new data to my Excel sheet from SharePoint and hit refresh, it will automatically update the Power BI report with the new data? Thanks for this, super helpful!
@@ChrisWagnerDatagod I can attest that this works - thanks! I have another question: I have a dataset with a Date column, Student ID column, and College column. Students change colleges from month to month and that transfer is captured in this report. How the $%$#%#$ can I track the # of transfer cases per month? I've been trying with the paid version of ChatGPT for 2 days now with no results and I'm about to die of frustration. Do you have a video that can help me?
How do you make this work when someone is sending you a new csv file every week with the same columns but more rows (No way to access the actual Oracle source). If I replace the existing file, will the link stay the same? Will the refresh work?
Thank you for this great video. But I have a problem that When I refresh this not update new table in my excel file. Just update data in old table. How we can update a new table or new column in power BI from excel oneline?
Any model changes like a new column or new column definition (string becomes an integer), you need to do that in Power BI Desktop and then republish the report.
Sir, I have a question, what if I enter more than one excel data, do I need to repeat the steps from the beginning such as entering links and so on or I just need to enter the excel data into one drive?
I would use this Excel to Power BI method if you already had an Excel that you wanted as a data source. I would look to connect Power BI directly to the other source if you were trying to automate the end to end process and NOT include Excel in the import strategy. Maybe have an Excel to show the data loaded in PowerBI, but not the other way around.
With Power BI Pro you can refresh up to 8 times a day. With PPU or Fabric, you can refresh as many times as you want. The UI allows you 48 times (on the hour or half hour), but you could use Power Automate or other tools to refresh more often.
It's good of its just one, but it will create a gateway connection for each file so it's a nightmare to manage the credentials when they expire. Also you can't leverage range names. Sharepoint.Contents might be the best way forward. A lot less pain to set up too.
![ROSÉ (로제) - number one girl [더 시즌즈-이영지의 레인보우] | KBS 241129 방송](http://i.ytimg.com/vi/A9oByH9Ci24/mqdefault.jpg)
![Digital Circus Episode 4 [TRAILER]](http://i.ytimg.com/vi/abZtsmMUbJo/mqdefault.jpg)
Mate, this video literally saved my job and mental health. I have been struggling to find the right solution to set auto refresh for months now and most of the videos I watched didn't really help. Your video is simple and straightforward. Answered all my queries. Thanks buddy, subscribed✌️
Well, thank YOU! Glad this helped.
HALLELUJAH! Sir, this is the SINGLE most helpful tutorial I have found for autorefresh. I have struggled with this for a solid three months now battling with the gateways. THANK YOU!
Glad it helped!
So if I add new data to my Excel sheet from SharePoint and hit refresh, it will automatically update the Power BI report with the new data? Thanks for this, super helpful!
This is SPOT ON! So nice, right?
@@ChrisWagnerDatagod I can attest that this works - thanks!
I have another question: I have a dataset with a Date column, Student ID column, and College column. Students change colleges from month to month and that transfer is captured in this report. How the $%$#%#$ can I track the # of transfer cases per month? I've been trying with the paid version of ChatGPT for 2 days now with no results and I'm about to die of frustration. Do you have a video that can help me?
How do you make this work when someone is sending you a new csv file every week with the same columns but more rows (No way to access the actual Oracle source). If I replace the existing file, will the link stay the same? Will the refresh work?
This should still work.
Thank you for this great video. But I have a problem that When I refresh this not update new table in my excel file. Just update data in old table. How we can update a new table or new column in power BI from excel oneline?
Any model changes like a new column or new column definition (string becomes an integer), you need to do that in Power BI Desktop and then republish the report.
Sir, I have a question, what if I enter more than one excel data, do I need to repeat the steps from the beginning such as entering links and so on or I just need to enter the excel data into one drive?
You will have to do this for each Excel source (even if the 1 excel file has 2 different tables).
Do we need to paste data in teams daily? Or is there anyway to automate that also?
I would use this Excel to Power BI method if you already had an Excel that you wanted as a data source. I would look to connect Power BI directly to the other source if you were trying to automate the end to end process and NOT include Excel in the import strategy. Maybe have an Excel to show the data loaded in PowerBI, but not the other way around.
Hands down great video. was looking for this. what if you'd like to refresh more than 4 tunes.
With Power BI Pro you can refresh up to 8 times a day. With PPU or Fabric, you can refresh as many times as you want. The UI allows you 48 times (on the hour or half hour), but you could use Power Automate or other tools to refresh more often.
I'll give it a go thanks
Let me know how it works for you.
It's good of its just one, but it will create a gateway connection for each file so it's a nightmare to manage the credentials when they expire. Also you can't leverage range names. Sharepoint.Contents might be the best way forward. A lot less pain to set up too.
You do not need a gateway for these. :)
Edit Credentials button not appearing to me. Any tips?
Can you take over the connection under the refresh settings?
Thank you so much is so useful !
Glad this was helpful!
Do u know, How amazing u r 🥰🥰 U helped me a lot 🙂🙂
My pleasure 😊
Thanks !
Welcome!
Thank you! This helped a lot!
Glad it helped!