Please join us for the next meeting on Monday, March 6th, at 6:30 PM ET. Leo Furlong (Senior Solutions Architect at Databricks) will share their point of view on why “the best data warehouse is a lakehouse.” For more details and sign up, visit our group page. PLEASE NOTE THAT OUR IN-PERSON MEETING LOCATION HAS CHANGED! WE STRONGLY ENCOURAGE YOU TO ATTEND THE EVENT IN…
Read article
I'm presenting at SQL Saturday Atlanta 2023 - BI & Data Analytics Edition on February 25th at 9 AM (the very first slot in the very first room for very first early birds). I'll do a Power BI Dashboard in an Hour this time to revisit the basics. I hope to see some of you there. Targeting novice Power BI users, this hands-on, no-slide session…
Read article
Microsoft announced a public preview of Power BI Dataset scale-out (DSO) for Power Premium, Premium per User (PPU), and Power BI Embedded. In the comments below the announcement, the article implies that this feature is a replacement for the Azure Analysis Services scale-out. "If you have an AAS scale out and you migrate your databases (aka models aka datasets aka cubes) to Power BI Premium,…
Read article
There has been a lot of noise surrounding a data lakehouse nowadays, so I felt the urge to chime in. In fact, the famous guy in cube, Patrick LeBlanc, gave a great presentation on this subject to our Atlanta Power BI Group and you can find the recording here (I have to admit we could have done better job with the recording quality, but we…
Read article Please join us for the next meeting on Monday, February 6th, at 6:30 PM ET. Patrick LeBlanc (Principal Program Manager at Microsoft and Guy in a Cube) will show you how to implement a lakehouse with Delta lake, Azure Data Factory, and Synapse. For more details and sign up, visit our group page. WE ARE RESUMING IN-PERSON MEETINGS AT THE MICROSOFT OFFICE IN ALPHARETTA. WE…
Read article
Suppose you need to calculate a percentage of grand total measure. Easy, you can use the Power BI "Show value as" without any DAX, right? Now suppose that you have 50 Table visuals and each of them require the same measure to be shown as a percentage of total. Although it requires far more clicks, "Show value as" is still not so bad for avoiding…
Read article
Scenario: You have an intranet web portal and use the Power BI secure embed feature (from the report menu, File->Embed report->Website or portal) to embed a report. However, the report doesn't render on iPad and iPhone devices. Instead, the user is perpetually asked to authenticate with Power BI. Solution: Apple has started preventing cross-site cookies to tighten up security. To resolve this horrible issue, each…
Read article The Atlanta MS BI and Power BI Group is resuming in-person meetings! Please join us for the next meeting on Monday, January 9th, at 6:30 PM ET. Elayne Jones (Data Engineer at 3Cloud) will show you how to integrate Synapse with Power BI. For more details and sign up, visit our group page. WE ARE RESUMING IN-PERSON MEETINGS AT THE MICROSOFT OFFICE IN ALPHARETTA. WE…
Read article
Expanding on my previous blog on this subject, there are three options to report-enable your Intranet portals with Power BI reports: Report link – This is the link to the report that you obtain from the browser address bar. If you want to report in full screen viewing mode (hiding the Power BI chrome), you can append the chromeless=1 query parameter to the URL, such…
Read article
The other day an exalted customer shared that they've acquired Synapse and now they're ready for implementing semantic models with Power BI. The client wasn't sure how to give business users access to Synapse so cool self-service BI can finally start. In the process of the conversation, it became clear that they opened Synapse Studio and were left with the impression that Synapse has semantic…
Read article
