How to Schedule REFRESH on File & Folder Sources in Power BI

Рет қаралды 17,554

Christine Payton

Күн бұрын

Пікірлер: 25

@taihornsby2480 Жыл бұрын

This is extremely helpful, Christine! Your content is always in line with some projects I'm doing at work lol

@bi-ome Жыл бұрын

I'm so glad! I feel like the "I don't have a data warehouse to work with" is more common than most people think, I've been there myself and it's definitely a struggle to automate in that space. :)

@apaththroughlife9721 Жыл бұрын

Always love watching your videos. It inspires me to be as productive as possible without "reinventing the wheel". I replayed the last 30 seconds at least 3 times because the screen recording in Power Automate desktop really caught my attention! Looking forward to seeing that when it comes out!

@bi-ome Жыл бұрын

Thank you!! Power Automate Desktop is a fun tool, you would think not from the outset but it seems to really promote creative thinking to get results in a strange way that I find really entertaining… I guess that’s a new level of Power Platform nerdery, lol

@apaththroughlife9721 Жыл бұрын

@@bi-ome you already know I’m all about the nerdery! Keep teaching us things, you are doing great at it!

@ahmedwalidmoulahoum2892 5 ай бұрын

This is very helpful. You have provided on-point tips to manage refreshes.

@genesiz7201 2 ай бұрын

Great video straight to the point and saved me hours of googling. Love the abi toads art ;)

@bi-ome 2 ай бұрын

thanks!! I love abi toads so much, wish they made more desktop backgrounds!

@mood902 3 ай бұрын

Simple, clear, and detailed explanation. Thanks!

@konanfranckraoul4078 3 ай бұрын

Good video, I love the best practices.

@hudamuhammed1978 3 ай бұрын

You are an absolute superhero!!!

@dganesh3641 4 ай бұрын

Amazing thank you so much - so useful!!!❤

@MicroStepswithBre 24 күн бұрын

Hi Christine! Does this work the same for JSON files? (I've followed your Planner steps/flow to create the JSON file previously.)

@bi-ome 24 күн бұрын

Yep! This works for any SharePoint Online / Microsoft 365 sources. Any file type-

@CH-rn6nc 2 ай бұрын

Hello. Great video. In fact, a lot of great videos. I have a question though. When I click on the ellipses once on the webpage, I don't see view dataset. I then clicked on "view semantic model", then I see the refresh button a the top, clicked schedule refresh, which then takes me to what looks like the screen you were looking at for auto refreshes. However, data source credentials is grayed out, and when I click on refresh all of the options under that section are also grayed out. Any suggestions?

@bi-ome 2 ай бұрын

Microsoft renamed datasets to semantic models, so you're in the right place! Are you the owner of the model? Only one person can own it at a time, so if it was published by someone else there will be a "take over" button at the top of the page. If that's the issue, then when you take over refresh you'll be able to manage credentials/schedule.

@CH-rn6nc 2 ай бұрын

@@bi-ome I am the owner. I was able to click on the name where you see the last refresh date and I am listed as the owner. So not sure what to do next.

@CH-rn6nc 2 ай бұрын

I figured it out! Basically, I had 1 index table to help order my AR aging properly that was linked to a file on my hard drive. As soon as I moved it over to the TEAMs folder where the other files are located, it allowed me to connect. Thanks again for the video.

@bi-ome 2 ай бұрын

@@CH-rn6nc Awesome!

@MichaelPowell-ic6nm 5 ай бұрын

Absolute lifesaver!!

@John.Amaddeo 4 ай бұрын

So, my company has restrictions with who has access to SharePoint. Also, I work in HR so the reports I use have confidential information. Is there a way I can utilize One Drive instead of SharePoint? For the time being, I'm looking to drop excel files to a location and have my Power BI refresh when I save a new file into said location.

@bi-ome 4 ай бұрын

OneDrive is basically a personal SharePoint site, so you can use that the exact same way. But, SharePoint is a better place for it - you can set the site permissions so that only HR has access. It's not public by default or anything. OneDrive is usually not recommended for business continuity reasons because if you leave, your OneDrive gets deleted with your account.