by Chris Webb | May 19, 2019 | Chris Webb
Jason Thomas and Gerhard Brueckl have both blogged on the subject of storing images as text inside a Power BI dataset: Embedding Images in Power BI using Base64 This post first appeared at http://feedproxy.google.com/~r/wordpress/Cpjz/~3/-9QW2-6k-M0/. The author...
by Chris Webb | May 17, 2019 | Chris Webb
What is the maximum length of a text value in Power BI? It turns out that this is a more complex question than you might think! The maximum length of a text value that the Power Query engine can load into a single cell in a table in a dataset is 32766 characters – any...
by Chris Webb | May 10, 2019 | Chris Webb
One of the many big announcements at Build this week, and one that caused a lot of discussion on Twitter, was about Wrangling Data Flows in Azure Data Factory. You can read the blog post here:...
by Chris Webb | May 8, 2019 | Chris Webb
DMVs (Dynamic Management Views) are, as the Analysis Services documentation states, “queries that return information about model objects, server operations, and server health”. They’re also available in Azure Analysis Service, Power BI and Power Pivot and are useful...
by Chris Webb | May 1, 2019 | Chris Webb
I’m one of those people who can’t resist peeking behind the scenes, and so when the Key Influencers visual appeared in Power BI I couldn’t help wondering how it worked its machine learning magic. Using DAX Studio to look at the DAX queries generated by the visual...
by Chris Webb | Apr 25, 2019 | Chris Webb
One of the most popular blog posts I have written in recent years is this post on how the RelativePath and Query options for the Web.Contents() M function can be used to allow datasets that use web services as data sources to refresh successfully in the Power BI...
