Category: Get to the Data
-
How to find which visual generated the query in Log Analytics?
Model metadata in Power BI is getting more and more accessable and there are a fair amount of tool that we can use to work with it. Report metadata on...
-
Log Analytics for Power BI: How to start and improve insights for better model performance
Categories: Get to the Data, Governance is keyI had a task to help a managed services team in monitoring multiple production datasets and reports in Power BI. These resources, accessed by thousands of users, demanded optimal performance. ...
-
Hidden features of Analyze in Excel - Part 3 - Focus
In the first two parts (part 1 and part 2) of the blog we explored the Show details functionality of a Pivot table in Excel. Now we look at another...
-
Hidden features of Analyze in Excel - Part 2 - Give me all the data
This blog series is about the hidden features in Analyze in Excel. There are lot of tiny details which can help the adoption of Power BI for Excel users. In...
-
Hidden features of Analyze in Excel - Part 1 - Show me the details
This blog series is about the hidden features in Analyze in Excel. There are lot of tiny details which can help the adoption of Power BI for Excel users. In...
-
Organizational Data Types - Supercharge your Excel users' productivity
Categories: Get to the Data, Improve the ExperienceData Types has been part of Excel for some time now, but a lot of people is not familiar with it. You can find them under the Data tab. You...
-
What are the options when a Power BI report is slow? - Power BI Performance Guide
This blog post want to help how to understand the reasons and give you a starting point for improvements in Power BI report performance. Won't cover all the options in-depth...
-
How to increase the value of your data - Open data in the UK
Categories: Big Picture, Get to the DataWhen we talk about getting insights out of data to drive decisions we generally think about "our" data that we collect. A value of our data is defined by value...
-
Getting Files (Folders) from SharePoint or OneDrive into Dataflows
Categories: Get to the DataWith the introduction of Dataflows in Power BI, the platform's capabilities have increased quite a bit. (Note: I'll do a detailed overview of Dataflows in another post.) Dataflows became generally...