Blogs

Does your organization use Power BI, Power Apps, or Microsoft Flow?

By Kenzie Jenson posted 3 days ago
Be the first person to recommend this.
Did you know we offer a full schedule of training courses for these products? Year-round we hold Academy training classes either virtually, on-site, or both. We’re bringing in the experts to deliver the knowledge and skills you need to leverage these products to their highest potential. Sign up for one of these spotlight classes or view the schedule of upcoming Power Academy classes here .   Academy - Design, build, test and implement your very own PowerApp! – Daniel Christian Academy - Getting Started with Power BI | 2 Day Workshop March 2019 – Christina Wheeler   Power UP! Event: Intro to PowerApps and Flow – unique, 2-day offering ...
0 comments

Power BI bulk Export using R-based function

By Michal Haviar posted 6 days ago
Be the first person to recommend this.
This guide is an extension of original article by Soheil Bakhshi . It shows how to add parameters, use them in R-based function and add some global environment references controls for more comfortable usage. Use this guide if you: Have relatively a small amount of data to export like a list of values or bridge tables. Want to utilize awesome Power BI ability to digest all kinds of data and use it as an ETL tool. Already applied some advanced M transformations (in my case it was Power Query data anonymization) and you want to save it back to your source database. Need to frequently export your transformed data, but don’t need to load it incrementally ...
1 comment

Telling a Story with Data

By Jessica Slyter posted 11 days ago
Be the first person to recommend this.
Story by Maggie Sparkman, senior content developer at Microsoft The Power BI World Tour made a stop in Seattle, Washington from October 29 - 30, 2018 to provide unprecedented Power BI content and DeNisha Malone’s session, “Telling a Story with Data”, was an excellent example of this… Lessons from DeNisha’s session: Tell a story Reports can’t just be a bunch of numbers, or even beautiful visuals. You need to find the story the data is trying to tell, and then make it clear. Keep it simple. A few clear visualizations are more powerful than a whole bunch of them all over the place. Find free data There are lots of free data sources out there! ...
0 comments

Back at Power Platform Summit in Amsterdam...the Microsoft Power Series

By Rose Spitzer posted 18 days ago
Be the first person to recommend this.
In addition to the 20 tracks lead by the community, technical experts and Industry luminaries presenting at the upcoming  Power Platform Summit  in Amsterdam, the Microsoft Team will be there in full force presenting the Microsoft Power Series track– over 15 hours of deep dive and hands on content.  These sessions are included in both the   Power Platform Summit  and   Dynamics User Group Summit Europe  conference passes and give you the unique opportunity to learn from the source and gain a view into the future of these products. If you are not familiar  Power Platform Summit Europe , 27-29 March 2019! This conference will be held at the RAI Amsterdam located ...
0 comments

December PUG of the Month Winner - Calgary!

By Jena Coffie posted 12-20-2018
Be the first person to recommend this.
Congratulations to  @Chris Sorensen ​ and the Calgary Power BI, PowerApps and Flow User Group for winning the December Challenge of the Month.  We spent some time with @Chris Sorensen to learn more about the group and plans for 2019.  ​ What has been the most exciting thing for your PUG so far? It has been two things. The first being getting the group going again with some momentum after a few years of on and off meetings. We have had three meeting with new leadership and our attendance has vibe had been quite positive. The second is evolving the group from just Power BI to the new Power Platform umbrella. I feel like Power ...
0 comments

My 5 Favorite New Features of Power BI Desktop November 2018 Update

By Markus Ehrenmueller-Jensen posted 12-10-2018
Be the first person to recommend this.
Seriously – a blog post about a monthly update for a tool which gets updates every single month anyways? How much of features can this contain, you might ask. A lot, I would answer. The product blog lists 14 (!) new features  alone for the November 2018 release. And it’s not the quantity, but the quality. Yes, some are of smaller and some are of bigger capability. But the majority will make your life easier, when working with Power BI. I promise you that you will be eager to install the new version and try those features out immediately. For me it’s even hard to decide which one is my favorite: Expand/Collapse in the matrix visual, copy & paste between ...
0 comments

My Top 5 Reasons for Taking Power Academy Classes

By Sue Whitney posted 11-29-2018
Be the first person to recommend this.
I’ve had the opportunity to attend several Academy classes: The CRMUG Administrator Blue belt and purple belt classes, Academy Excel Power Pivot, and Academy Power BI Blue belt.  Here are my top 5 reasons for taking these classes: 1. Lifelong Learning is a Positive Experience The benefits of lifelong learning are numerous: it helps you enhance your mind and keeps your thinking sharp. Learning also keeps the creativity flowing and it’s also been scientifically proven that active learning is a great exercise for the brain- which is an area I want to keep in top shape. 2. Expands My Skill Set I love my job and where I work but that doesn’t mean I ...
0 comments

Roadmap Presentation in PowerBI

By Anca Cocosco posted 11-19-2018
Be the first person to recommend this.
​Hello  I am new to this forum, so I do hope I am using the correct forum for this type of questions. I have seen and used many visuals related to various KPIs (financial and such), but I am having a hard time find the right visual to represent a Roadmap. I am currently using the Gantt visual, and Gantt visual by MAC Software, but they are a little bit limited in terms of visual representation and I find them slow at times (also text gets cropped in a weird way, etc)  I am trying to get close to what I was using in PowerPoint as the Timeline AddOn to the powerpoint. Can anyone point me in the maybe right inspirational direction? Many thanks Anca C
1 comment

November PUG of the Month Winner - Kharkiv

By Quinne Germain posted 10-30-2018
1 person recommends this.
Congratulations to @Ruslan Zolotukhin and the Kharkiv Power BI User Group for winning the November Challenge of the Month. We spent some time with Ruslan to learn more about the group. ​​ What has been the most exciting thing for your PUG so far? PUG community connects you with other groups to exchange experiences. You can attend other group webinars and meetings with Power BI rock stars 😊 There is a lot of additional stuff. We have been at local data conferences where we mentioned that we have local Power BI User Group in Kharkiv. Most of the people didn’t know that, and some of them even became interested.   What makes your group successful? ...
0 comments

Our first Power BI custom visual - Column Chart with Variance

By Matthew Gierc posted 10-26-2018
Be the first person to recommend this.
Hello Power BI Enthusiasts! A few months ago we published our first Power BI custom visual titled Column Chart with Variance. It's free, and you can find it  here .  So far we've had good feedback from people who have used it, but we're always interested in getting more, especially from "Power" users. Please feel free to hit us up with any comments or questions. Also, we wanted to share a little about our philosophy behind developing this visual. If you're interested in learning more, please check out our blog post .
0 comments

Free-to-use Power BI Tutorial Report

By Stephan de Jong posted 10-10-2018
4 people recommend this.
Hi fellow Power BI enthousiasts! To properly set up the use of Power BI within your organization, it is usually necessary to give users some training. For users who only consume reports a short training, in which the possible interactions of a Power BI report are explained, is often sufficient. One way of doing this is by using a step-by-step tutorial report, that can also serve as a reference document within Power BI itself. In the past few months I have already built such a Tutorial for some of my customers, which they are now using in their Power BI Apps. For those of you who are also interested in adding a Tutorial to their Power BI environment, I am ...
4 comments

Search exactly matched String/Text in PowerBI

By Ranjit M posted 10-09-2018
Be the first person to recommend this.
Hi, I want to search exactly matched String/Text from multiple columns. FYI below, If i search for ServiceName='NETWORKING' then it should display matched records. Please suggest me how to achieve this.
0 comments

Developing with Power BI Embedding

By Ted Pattison posted 10-04-2018
Be the first person to recommend this.
In the three years since its initial release, Power BI has become widely-adopted by corporations and other organizations as a Software-as-a-Service (SaaS) application. The Power BI Service provides licensed users with the ability to access and interact with Power BI reports and dashboards through the Power BI portal which most users access through the URL of https://app.powerbi.com. The Power BI Service also provides licensed users with a first-class mobile experience using the Power BI Mobile apps that Microsoft has published for iPhone, Android and Windows 10. Microsoft promotes Power BI along with PowerApps and Flow as the primary services in the Microsoft ...
0 comments

Data Modeling 101 with Power BI

By Erich DeJesus posted 09-18-2018
1 person recommends this.
Hello All,  This is our second ATL local workshop  Data Modeling 101 with Power BI  Data is available in many forms. Structuring the data in a way that is easy to consume often presents a challenge. In this session, we will walk through some basic Data Modeling techniques that can be done using all the tools built into Power BI. If that isn’t enough, we will also show you how to centralize the completed model, presenting a central version for all end-user reporting. Bring your laptop, because this is a hands-on lab. Agenda 30 min 11:30 AM Arrivals and Networking: 60 min 12:00 PM Lunch by Provided Aptude, Inc 120 min 1:00 PM - 3:00 PM Workshop ...
1 comment

Calculating pervious and current sales in direct query

By PANTRY COUPON posted 09-04-2018
Be the first person to recommend this.
Hi All. Im new to PBI. Im getting data from Hana. what is the best direct query formula to calculate PY and CY  sales  Please Help Thanks P
0 comments

Calculating pervious and current year sales in direct query

By PANTRY COUPON posted 09-04-2018
Be the first person to recommend this.
Hi All. Im new to PBI. Im getting data from Hana. what is the best direct query formula to calculate PY and CY  sales  Please Help Thanks P
0 comments

Connecting with Users through the PowerBIUG Partner Program Benefits Business

By Sue Whitney posted 08-22-2018
Be the first person to recommend this.
How Connecting with Users through the PowerBIUG Partner Program Benefits their Business   An interview with Ben Douglass, Global Marketing Director, ZAP (PowerBIUG): What’s your favorite part about being part of the PUG Community? (BD) : The best part is getting the chance to discuss the challenges of data preparation and governance with Power BI users. It also gives our experts a platform to share their experiences and knowledge on the subject to PUG members. We enjoy attending events and spending time with the community face-to-face – it’s good to get the chance to meet people (outside of the constraints of email!) and get a sense of what’s on ...
0 comments

Azure data sources in Power BI

By Erich DeJesus posted 07-26-2018
Be the first person to recommend this.
Join Patrick Leblanc and Erich Dejesus on a  hands-on workshop where we will demonstrate how to leverage Power BI to connect to various Azure-based data sources. They will connect to sources such as Data Lake, CosmosDB, Blog Store, Azure SQL, Azure SQL Data Warehouse, etc.. Step-by-step details will be provided so that each attendee leaves with skills and knowledge to implement this when they are back at their desk. The only requirement is to have an Azure subscription you can create one free in this link   https://azure.microsoft.com/en-us/ This event is only for local user in ATL . Register Here: https://www.eventbrite.com/e/azure-data-sources-in-power-bi-tickets-47919398210
0 comments

Power BI World Tour -- Meet Your Speakers!

By Jena Coffie posted 07-24-2018
Be the first person to recommend this.
The Power BI World Tour sessions for first three cities of this global tour are now available! Get a look at the popular topics and sessions planned for you, and get to know your speakers! Melbourne (August 21-22) Kelly Broekstra David Alzamendi Charlotte (August 28-29) Melissa Coates Angela Henry Sydney (August 28-29) Peter Myers More speakers and details are being confirmed each day so check back regularly for updates! www.powerbiworldtour.com #PowerBI #PowerApps #Flow #PBIWorldTour ​​​
0 comments

New Features & Look for the Power BI User Group (PowerBIUG)!

By Marghet Hager posted 07-18-2018
Be the first person to recommend this.
We are very excited to announce that  PowerBIUG   (formerly PUG) has a fresh new look! On top of that,  we are excited to  introduce  PowerAppsUG   –   a new site to connect PowerApps users with each other.   L et’s take a tour of some of the new personalized features which will help you better see relevant discussions and upcoming events.   Easily Access User Groups   With the new Utility navigation on the top bar, you can seamlessly access  PowerBIUG ,  PowerAppsUG , and other user groups without leaving the site. You can use your same login credentials for the User Group for Dynamics 365 ( D365UG.COM ) site, giving you ...
0 comments