Please join us online for the next Atlanta MS BI and Power BI Group meeting on Monday, October 3rd, at 6:30 PM ET. Tom Huguelet (Lucient) will present a real-world case study and the challenges involved in bringing a Power BI application from initial Excel-based POC to an ISV platform that auto-provisions for new clients, using Power BI Embedded Azure Premium Capacity. For more details…
Want to display a visual-left hint to perplexed users that explains what your visual is supposed to reveal? Like me, you've probably missed the handy Power BI help tooltips feature that allows you to pop up some helpful text for each visual. On the Format tab of the visualization pane, expand the Help Tooltip section, and enter the text. Then, a question mark glyph shows…
BI implementation shortcuts are tempting and disguise themselves as cost-effective. True, you can slap a Power BI dataset on top of your data (the cornerstone of self-service BI), but most BI implementations will greatly benefit from a datamart, irrespective of the propaganda of self-service BI vendors. I explain the benefits of datamarts vs Power BI datasets directly on data sources in my blog “Datasets vs.…
Scenario: You need to rename many columns in a Power BI table. Usually, I rename measure-related columns with "Base" suffix and hide them, and then I create explicit measures. Since renaming one column at the time is no fun, you're looking for an automated solution. Having heard about the Tabular Editor scripting feature, you're tempted to whip out a script like this: You select all…
Scenario: You use SSIS to load data for on-prem BI solution. As a last step of the ETL pipeline, you want to refresh a Power BI dataset. There's quite a bit of misinformation on the Internet about how to do this, hence this blog. Solution: If the dataset is hosted in Power BI Pro workspace, the only way is to use the Power BI REST…
Please join us online for the next Atlanta MS BI and Power BI Group meeting on Monday, September 12th, at 6:30 PM ET. Shabnam Watson (Microsoft MVP) will discuss how to reduce the dataset refresh time with incremental refresh policies and how to implement tables with hybrid storage. For more details and sign up, visit our group page. Presentation: Incremental Refresh and Hybrid Tables in…
