MS BI fans, join us for the next Atlanta MS BI and Power BI Group meeting on November 4, Monday, at 6:30 PM at the Microsoft office in Alpharetta. Andy Lawrence will share best practices for impactful Power BI Dashboards. CCG Analytics will sponsor the meeting. For more details, visit our group page and don't forget to RSVP (fill in the RSVP survey if you're planning to attend). Presentation: Best Practices…
Read article
Every now and then I get a question about how to secure Power BI report pages. A business analyst has created a multi-page report that requires limited access to some sensitive information in one or more report pages. I always cringe at this idea and recommend securing the data instead. That's because report-level or dashboard-level security can be easily compromised. For example, if the user…
Read article
Power BI lets you filter the visual data by a measure, such as by a measure that dynamically calculates the customer's rank. This is convenient but there are performance implications related to the way Power BI autogenerates the DAX query. If a visual has a visual-level filter on a measure, Power BI Desktop defines a variable table filter that includes all measures in the visual.…
Read article
A discussion overheard between two attendees at SQLSaturday yesterday: What is this Tabular thing? Like a cube but better. How's it better? It's in memory. I wonder if it can improve the performance of my report… It should, it's also in the Cloud. Note to myself. Use "in memory" and "cloud" more often.
Read article
SQL Saturday Atlanta (BI Edition) will be held on October 19th. I'll present a "Power BI Pro, or Premium: that is the question" strategy-oriented session at 12:30. One question that always pops us during my Power BI assessments for companies planning to adopt Power BI is which SKU to buy. The choice might seem obvious to your organization, but there is much more below the…
Read article
MS BI fans, join us for the next Atlanta MS BI and Power BI Group meeting on October 7, Monday, at 6:30 PM at the Microsoft office in Alpharetta. Qubole will show us how Presto, Azure Data Lake, and Power BI can be used to analyze Big Data. Qubole will sponsor the meeting. For more details, visit our group page and don't forget to RSVP (fill in the RSVP survey if…
Read article
