The European SharePoint, Office 365 and Azure Conference returns to an in-person event this year, Nov 28 – Dec 1 in the beautiful city of Copenhagen, and we are delighted to announce our Call for Speakers is now open. SUBMIT TO SPEAK If you have an interesting story to tell and expertise to share, we invite you to submit… READ MORE
The European Power Platform Conference Call for Speakers closes this Thursday. SUBMIT TO SPEAK TODAY Have an idea or session to share at The European Power Platform Conference? Then we’d love to hear about it. With an expected audience of 500 attendees, European Power Platform Conference will give you the opportunity to share your expert knowledge with the community while building… READ MORE
It’s been a while that I use Microsoft To Do to organise my daily tasks. From work-related tasks to buy groceries. While Microsoft To Do is super easy to use but there are some challenges in using it more efficiently, especially when you have multiple O365 accounts within different organisations. Here are some of the challenges I faced; you… READ MORE
Power BI doesn’t yet have a feature that allows end-users to turn on/off the ability to process calculations for visuals on a report page until they are ready. Most of the time, this is perfectly fine – however, in some instances, it can be handy to disable long-running and heavy calculations from running. At the… READ MORE
SharePoint and Power BI can work very well together. SharePoint can be a data source (lists), a container for data files (Excel. CSV etc in libraries), and as a dashboarding platform (pages). This demo rich session will explore all of these scenarios in great depth. SharePoint data can be finicky to retrieve, and this session… READ MORE
Migrating data sources at times can be tricky in Power BI. This article focuses on how to change the data source from an Excel table to a SQL table in minimum possible steps, considering the following scenarios: The name and structure of the data source tables are different in Excel and SQL. It includes a… READ MORE
Recently I have been working where I have multiple accounts, and I wanted to test the different access to the accounts when connecting via Excel. Today we will discuss Changing the User Account in Excel when connecting to Power BI Premium/Per User or Azure Analysis Services. I could not find any blog posts or videos… READ MORE
I have been playing around with the new awesome (preview) feature in the December Power BI Desktop release where we can use DirectQuery for Power BI datasets and Azure Analysis services (link to blogpost) In my case I combined data from a Power BI dataset, Azure Analysis Services, and a local Excel sheet. The DirectQuery… READ MORE
Most dataflows needs to have scheduled refresh setup so that the data will be up to date ready for the reports connecting to it. This post walks through the basic steps to set up the refresh. Dataflow Series This post is part of a series on dataflows. Create a dataflow Set up dataflow refresh Endorsement… READ MORE
Once upon a time, your old scary DBA walked into your office with a red-colored face and asked you furiously: “What the hell you’ve done with your Power BI report?! It killed all of our workloads!!!” You knew why he was angry, even before he started screaming at you. It’s because of “that” report which… READ MORE
