Power BI

I worked on a Power BI embedded POC where a report with an in-memory Power BI model as the dataset was embedded into an application in an “app owns data” scenario. This means that the a…

The site home page

#Azure #analysisservices importing a #powerbi model- Demo by @donsvensen at #azure meetup Dublin pic.twitter.com/Gl5nQIWN36— Wolfgang Strasser (@wstrasser) April 25, 2018

Thoughts and Lessons Learned From A Power BI Embedded POC (@mmarie) Introducing Lingo (@powerbitips) Regex in Power BI and Power Query in Excel with JavaScript (@TheBIccountant) Power BI Tips & Tricks from the Trenches (@RuiRomano) Power BI Announcements in Data&BI Summit 2018 Dublin Keynote (@Rad_Reza) BONUS ITEMS: Using OR conditions between slicers in DAX (@marcorus) […]

powerbi-desktop-samples - Power BI Desktop sample files for the monthly release. Here you can find the PBIX files used in the monthly release videos.

Here is my weekly BI-RoundUp and it is great to see that the monthly update for Power BI is here, as well as some other details of the new items. Power BI – Update for May 2018 As always here are t…

In my “Why Business Like Yours Choose Power BI Over Sisense” blog, I discussed how Sisense seeks a competitive advantage by offering a user-friendly designer connected to the their ElastiCube, thus cl…

Last Friday, I created a prototype Power BI “Slicer pane” and posted it to social media. It generated a more positive response than I would have thought. After fulfilling a client request that afterno…

This month we have major updates across all areas of Power BI Desktop. Along with many other reporting features, we have our biggest update to conditional formatting in while, the ability to format an…

Extract data from a Web page by providing an example of what you want to pull

Learn how to enable very large datasets in the Power BI Premium service.

Power BI just recently released the ability to set up Incremental refresh policies through the Power BI Desktop. This is a short blog post with my first thoughts on it. Everybody has been excited about the possibility of doing Incremental Refresh through Power BI. Back in the day, this was only something that you could …

If you missed my webinar in February, today is a great opportunity to watch it, and practice your Power BI skills with Star Wars data: Download the solution file (.pbix) here. More resources: Star Wars Challenge – Row Level Security in Power BI here. Our source data is provided by SWAPI, The Star Wars API: https://swapi.co/ Related

It is easy to look at Power BI dashboards as static, but you can use some old school techniques to provide the ability the generate dynamic content using data-driven global settings that will be available to all your report developers. These techniques will allow your published reports to remain unchanged but allow the reports to dynamically reflect default information shown to the user, such as Current Month, Report Comments and even a time stamp of the last data source update.

Power BI: How to import data from another Microsoft PowerBI service model using the OLE DB provider

I have done a few videos on YouTube explaining how to join tables using Power Query or DAX. If you follow the channel, you probably have seen the videos and this blog post will serve as a compilati…

In April of 2018 the Microsoft team released the ability to edit the Linguistic schema in Power BI desktop. For those who are not aware [...]

In a previous post, I wrote about the fact that Power BI did not have the capability to Mark a table as date, but that has changed! Now if you want a date table to use numeric keys to join to other…

Last week I presented a session Power BI Tips & Tricks from the Trenches at Data & BI Summit in Dublin. One of the tips was on how to “Get Data from PowerBI.com”: My colleague J…

The new driver comparison tool uses historical data from NASCAR’s robust data warehouse to compare two drivers at all the tracks on this year’s schedule. Now, for the first time, fans can compare the full racing profile of two drivers all in one place. This is just the first step in a greater effort for NASCAR to share race data with fans in a new and exciting way.

We’re excited to announce registration is open for the first-ever Microsoft Business Applications Summit, coming to Seattle July 22–24! Combining the best of the Microsoft Data Insights Summit, Convergence, and the Dynamics 365 Technical Conference, this new event is designed to help you create the best, lasting solutions for your business.

Take a look at these great resources to help you achieve success in Power BI. Guest author George Squillace shares 12 places to help you better use Power BI.

Using bookmarks for clearing all slicers in Power BI is not a a new function, I have been using it for many months, and advising many people to do it that way. However, I still get a lot of questions …