Blogs

2 people recommend this.
Have you heard of a Power BI SIG.. as in a special interest group? If your answer is No, that's OK. You're not alone. Power BI SIGs or Special Interest User Groups , are the hidden gems of the PUG community. Why? Because all you have to do is have an internet connection and a laptop, and you can have the full benefits of a community online, with 100's of others with similar interest across the world. Unlike the popular Power BI user groups, SIGs are very focused on a specific type of user, line of business or skillset. As one of the leaders for Power BI for Business User SIG, our focus is to help business users focus on how to really ask ...
1 comment
1 person recommends this.
Two years ago my colleague Dave Ruijter ( t | in ) started the Power BI Cheat Sheet. First, it was a giveaway for participants of our classroom Power BI training with a summary of the tips and tricks we shared during the training. Not long after that, Dave decided to make it publicly available! Besides our tips and tricks, it also became community driven which results in a lot of input from the community via social media nowadays. Over a year ago, I ( t | in ) joined Macaw and started to help Dave with keeping the Cheat Sheet up-to-date, which is actually kind of a hard job with the fast release cycle of Power BI. The Power BI Cheat Sheet is a one-page ...
1 comment
1 person recommends this.
On the closing day of activities in Amsterdam last month, industry experts, analysts, and power users gathered for the Town Hall at Power Platform Summit Europe to hear User Group announcements and take advantage of the opportunity to engage with the Microsoft Power Platform team for product Q&A. Kicking things off, the Power Platform User Group Team took the opportunity to announce and recognize those in the community that have made an impact on users. There are many amazing volunteers writing blogs, delivering webinars, instructing academy boot camps and presenting at regional events. They selflessly give of their time and knowledge to further the education ...
0 comments
2 people recommend this.
Congratulations to co-leaders  @Vali Abdykarim ​  @Jose Almeida   @Ben Watt   @Ted Murphy   @Liam O'Neill  and the  Dublin PUG for winning the February Challenge of the Month.  We talked with the group’s leadership team to learn more about the group and plans for 2019.  ​   What has been the most exciting thing for your PUG so far? It's hard to name one exciting thing as we have a lot to be excited about, but the most exciting for our community would be securing a permanent venue for Dublin PUG for all of 2019.   What makes your group successful? We defined our core values as networking and learning - so we have engaged with our community ...
0 comments
Be the first person to recommend this.
Many organizations are adopting the Power Platform because PowerApps and Flow make it so quick and easy to build business solutions without any need for the traditional software development life cycle. However, the ease of use of PowerApps is a double-edged sword. While it's relatively easy to get up and running with PowerApps, you’ll also find plenty of ways to get yourself in trouble and to create the canvas-app-from-hell that's impossible to maintain and evolve. While the Internet contains an infinite supply of blogs and youtube videos focused on PowerApps, there's not much content that answers the essential question. How do I ensure that I'm building ...
0 comments
1 person recommends this.
Most of us usually create joins on Date Values when we create internal date dimensions on PBI. Below is the case when actually it doesn't work properly. Let me brief a bit about data sources. 1- PostgreSQL 3- Date dimension created internally using Calendar function.  4- all the joins are on date column and they are working perfectly on PBI Desktop even after refreshing the data from PBI Desktop. When I published that on Server(PBI Report Server) report was running fine unless after Schedule refresh for Power BI Report. What actually was happening is that - Schedule was running on time - Schedule completed successfully - As soon as it completes all/most of ...
0 comments
Be the first person to recommend this.
 En este blog mostrare como usar Azure ML Studio -web service- en Power BI, usando Power Query. Efectivamente, cuando se desarrolla un modelo de Machine Learning o Analisis Predictivo con Azure ML Studio, ademas de poner el modelo en produccion, Podemos usar las capacidades de Power BI para visualizar y analizar los datos de resultado que se producen despues de que el algoritmo procesa los input. Azure ML Studio Debe crear un modelo en Azure ML Studio y crear un servicio web para él. ¿El ejemplo tradicional en Predecir un pasajero en un barco Titanic va a sobrevivir o no? Tenemos un conjunto de datos sobre pasajeros como su edad, género ...
0 comments
Be the first person to recommend this.
This article has previously appeared in the Global Power BI User Group, but has been republished for a bigger audience. Hi fellow Power BI enthusiasts! To properly set up the use of Power BI within your organization, it is usually necessary to give users some form of training. For users who only consume reports it is often sufficient to follow a short introductory training in which the possible interactions of a Power BI report are explained. One way of doing this is by using a step-by-step tutorial report within Power BI itself, that can also serve as a reference document. In the past few months I have already built such a Tutorial for ...
0 comments
Be the first person to recommend this.
The Power Platform World Tour (formerly referred to as the Power BI World Tour) is well underway as it recently wrapped up its second stop in Silicon Valley, California. With 24+ breakout sessions covering topics across the entire Power Platform, expert speakers, and great conversations fueled by gallons of coffee, it’s easy to see the excitement building within the Power Platform User Groups. Afterall, when else do Microsoft team members, users of Power BI, PowerApps, and Flow, and industry experts gather together to bring content closer to the local community? This is the time to push the boundaries of current business practices by focusing on empowerment, ...
0 comments
Be the first person to recommend this.
Recently the Power BI User Group sat down with Microsoft Senior Product Manager and Power Platform Summit Power Series speaker Alon Baram to learn more about Power BI Embedded and his upcoming session,  Deep Dive into Power BI Embedded , happening in Amsterdam this March. He shares about what's new, best practices for multi-tenancy, easier to create app-only authentication, and more - including what assets help drive future service planning. PowerBIUG: What will users take away from your two hour Power Series session at Power Summit?  Baram: Users will experience hands-on how in few easy steps, they can embed Power BI visuals in Web portals and applications ...
0 comments
Be the first person to recommend this.
En el update de Febrero de 2019, esta disponible (en estado ‘preview’) la primera visualización de AI: Influenciadores clave.  Las visualizaciones de AI utilizan el aprendizaje automático para razonar sobre sus datos de una manera natural, con la intencion de aprender y determiner como influyen determinadas variables independientes sobre otras variables -dependientes-. Una vez se elige un KPI que desea analizar, la visualización de los influyentes clave (Key Influencers) determina qué es lo más importante para controlar su métrica y también encuentra segmentos interesantes para que se investigue. Una vez que active la función de vista previa a través del ...
0 comments
Be the first person to recommend this.
If you have only ever played in the Power BI Desktop, and never ventured into the Power BI Service, you may not be aware of what a Workspace is.  But once you start using the Service, you will definitely need to understand what workspaces are and how they function. In  March, I am going to tackle this subject in a webinar and a discussion group. (Check back under the Webinars tab to register for these two events.) These webinars will be focused on beginner business users, so if you are just getting started in Power BI, this is for you. I promise, I won't assume anything and won't use jargon. Also, please be sure to join the Business Users Special Interest ...
0 comments
1 person recommends this.
Congratulations to @Anne Walsh  and @Martin Loughman and the  Galway PUG  for winning the January Challenge of the Month.  We talked with @Anne Walsh and @Martin Loughman  to learn more about the group and plans for 2019.  ​   What has been the most exciting thing for your PUG so far? Definitely having MVP @Ruth Pozuelo Martinez  to launch our user group was the most exciting thing so far.  Ruth demonstrated her famous "Billionaire" Power BI report and showed us how she put it all together. With 18,000 subscribers to her YouTube channel Curbal, she’s a great champion and promoter of Power BI across the world.   What makes your group ...
2 comments
1 person recommends this.
User Group Focus for the Power platform (includes Power BI, PowerApps, Microsoft Flow) March 13-14, 2019 in Houston, TX  In its fourth year,   User Group Focus for the Power platform   is heading to Houston, TX this March 13-14. This immersive event offers 90-minute, multi-level sessions on PowerBI, PowerApps, and Microsoft Flow. All sessions are deep-dives, presented by technical and functional experts, MVPs, and Microsoft team members. Why should you attend? An intimate event, User Group Focus offers a unique opportunity to sharpen your skills and learn best practices to further your job role, career, and product investment. This will result ...
0 comments
Be the first person to recommend this.
The turnout was strong at the Power Platform World Tour in Tampa with over 100 attendees; many of them established IT managers, developers and business analysts across various industries. There were a handful of new Power users, several Microsoft employees and a very enthusiastic group of University of South Florida student, all eager to learn about new features, updates, and trends of Microsoft Power BI, PowerApps and Flow content. The two-day event provided attendees with the opportunity to select from 26 breakout sessions, broken out across 3 tracks including New Business User , Power User and Technical. Some of the highest attended sessions ...
0 comments
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
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

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
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
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