by Paul Hansen | Nov 29, 2021 | Power BI
You can now create reports connected to Power BI datasets from a blank workbook in Excel for the web. This post first appeared at https://powerbi.microsoft.com/en-us/blog/create-connected-pivottables-in-excel-for-the-web/. The author is Read...
by Chris Webb | Nov 28, 2021 | Chris Webb
In my quest to check out every last bit of obscure Power Query functionality, this week I looked into the ContextInfo option on the Sql.Database and Sql.Databases M functions. This option allows you to set CONTEXT_INFO in SQL Server (see here for a good article...
by Matt Allington | Nov 23, 2021 | Excelerator BI
I have been waiting for this feature to be delivered for a while. Until this week, the only way to export data from Power BI was to do it into a source data table. That meant that if you had data laid out like shown below, and you exported it […]Read More » This...
by Chris Webb | Nov 21, 2021 | Chris Webb
Back in September I posted about a few new Power BI-related books I was given to review for free; that post led to me getting sent another freebie book, “Extending Power BI with Python and R”, by Luca Zavarella (buy it from Amazon UK here). I found this book...
by Paul Hansen | Nov 18, 2021 | Power BI
Capacity settings for datasets now in Power BI Premium Gen 2! This post first appeared at https://powerbi.microsoft.com/en-us/blog/capacity-settings-for-datasets-are-now-in-power-bi-premium-gen2/. The author is Read...