One of my favorite features of Power BI is the ability to have published reports automatically refresh data on a schedule. This is great for “setting and forgetting” your reports, knowing wherever you publish them they will be showing the most recent data for your clients. I feel like it used to be depending on your license, you could be limited to how frequently you can refresh (max of once per day), but you can refresh nonetheless. And this may have changed, as I couldn’t find (in my brief search) any confirming statement.
Let’s set up that scheduled refresh!
Continue reading “Automatic, regular data refreshing for Power BI reports”
When working in Office 365 or SharePoint and you open a document for editing, you get two choices. Edit in Word (or Excel) or Edit in Browser. Editing in browser is typically a safe route but it doesn’t give you full functionality like the clients will.
The issue I’m discussing here is when a user tries to edit a document from SharePoint using the client (not Edit in Browser) the client opens to a blank, gray background (no document) or doesn’t open at all. This is likely an account conflict in syncing or accessing.
In other cases, the document may open, but as read-only. If that’s the case, it’s likely permissions-related. You might first check the user’s specific permissions in SharePoint. Sometimes because of broken (not inherited) permissions, or partial access to a site, users are able to edit in browser, but not in the client. If this is your situation, it could well be the cause.
Hopefully this is a simple fix for you, but as it’s become clear to me a number of times with this issue it can be quite complicated. I have a couple fixes, though the second is less ideal. If anyone else has run into this and would like to offer their experience, please do so in the comments.
Continue reading ““Edit in Word” (or Excel) not opening document in Office 365, or “Read-Only” status upon opening and trying to save changes”
The new SharePoint framework has a lot to offer in the way of development possibilities and user-friendliness. Creating a page using their new default page experience seen above is much more intuitive, inherently mobile-friendly and easy to whip together some decent-looking dynamic content in just a few clicks. But this new experience doesn’t allow for adding web parts like you may be used to. And customizing layouts isn’t as accessible as it once was. The following few steps will allow you to create a page that utilizes familiar layouts (columns and sidebars) and web parts.
Continue reading “Create old web part page instead of using SharePoint framework’s new page experience”
So you want your viewers to know the last time data was refreshed or updated in your SharePoint list without having the list’s default “modified” column repeating the same date hundreds of times and taking up horizontal space.
There are a number of solutions out there to show the date a list was last modified using code. This solution provides an option best used with lists you bulk update, or copy and paste to replace all data regularly, but requires no coding. It basically pulls out the “last modified” date of your first list item and displays it at the top as seen above. This solution is not for you if you are updating only specific items within a list.
Continue reading “Show last modified date for a SharePoint list without using code”
Depending on your organizational setup, this message may be misleading. For me, this message is prompted when I change my password used to sign in to Office 365. My version of SharePoint Designer (SPD) is not, in fact, out of date at all. My organization regularly requires password changes so these steps get me back and running with SPD in less than a minute:
- After opening SPD, go to “Accounts” in the left hand menu
- Under “connected services” remove connections for whatever could be causing the issue
- Click “add a service,” then “storage,” then “Office 365 SharePoint”
- Login with your new credentials. This should also link any OneDrive for Business account associated with your O365 account
If a password change isn’t what prompted your issue, try going to “Account” then “Switch Account” to make sure it’s attempting to connect to the correct account.