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.
Hello,
I'm really new to Power BI and am having trouble finding information on data refresh - there's lots of information out there but I'm struggling to find what's current.
What I want to achieve is an automtic refresh of the data in my report that sits in the powerbi.com service.
Here's what I've done:
To get the data into PowerBI.com I have tried 2 approaches, neither of which worked as i would have expected:
I'm assuming I must be doing something wrong so the question is this: Can I create a report using the Power BI Desktop (that is based on an Excel file stored in OneDrive for Business) and have any changes to the Excel file automatically refreshed in the Power BI Service??
Thanks in advance,
Rich
Solved! Go to Solution.
yes, once you loggied in to your dataset, you should be able to setup schedule refresh, and the expected behaviour is that at every schedule run (max of 8 in a day), you will get to see refreshed data.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@RBlakeDid you had chance to look at this post, you can refresh your dataset using "schedule refresh"
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @parry2k,
Thanks for getting back to me. I did read this article. I took the following from this article - if you have a PBIX file that is based on a local source (non o365 cloud) then you need a gateway or if you upload an Excel file from OneDrive for Business to the service then you'll get an hourly refresh.
I have a PBIX file stored in OneDrive for Business using data from an Excel file also stored in OneDrive for Business. Schedule refresh didn't work for me and OneDrive refresh isn't an option so are you saying I need a gateway to accomplish the refresh?
Cheers,
Rich
@RBlakeAs far as I know you don't need Gateway if you source is ondrive for business. DId you had setup dataset credentials in PowerBI Service?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Yes, OAuth2 and i was logged in...
Is the expected behaviour that my report page should see a data refresh??
Thanks again,
Rich
@RBlake did you ever get this to work out? I'm in exactly the same spot with not getting data refreshed off a publish desktop report. Instructions are quite unclear on this IMO.
yes, once you loggied in to your dataset, you should be able to setup schedule refresh, and the expected behaviour is that at every schedule run (max of 8 in a day), you will get to see refreshed data.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |