I have already blogged in great detail many times about Power BI/Power Query data privacy settings (see this series for example) but there’s always something new to learn. Recently I was asked a question by Ian Eckert about how Power BI handles data privacy for cloud or web-based data sources after a dataset has been published, and it prompted yet more revelations…
Tag Archives: Data
Data Privacy Settings And Data Refresh Performance In Excel And Power BI
I have known for a long time that data privacy checks can have an impact on the performance of data refresh in Power BI and Excel, but on a recent performance tuning engagement I had the chance to observe just how much of a difference changing these settings can make
Credentials, Data Privacy Settings And Data Sources In Power Query/Power BI
Recently I’ve been doing some more investigations into how data privacy settings work in Power BI. This is a subject I’ve blogged about in great detail already in a series of posts last year, but this functionality is so complex that there is always more to learn. I don’t have any profound new insights to offer; instead this blog post is a write up of a series of experiments whose results shed light onto how the process of setting data privacy levels works end-to-end.
The CredentialQuery Option For Web.Contents() In Power BI Custom Data Connectors
There’s a new, as yet undocumented, option for the Web.Contents() M function that is only available for custom data connectors and not in Power BI Desktop: CredentialQueryOption. It does the same thing as the Query option, but it stops the values you are passing to the query parameter from being logged in Power BI’s diagnostic logs, so it’s useful if you are passing sensitive information such as passwords.
Data Profiling in Power BI
Today Microsoft released the October 2018 update of Power BI Desktop. One of the fabulous new features that has been released is the ability to get a visual profile of your data in Power Query BEFORE you load the data. This new feature is typical of the type of development effort Microsoft is investing in with its products. MS is trying to make your life easier by helping you with the tools you need to do the job without you having to do everything yourself from scratch.
Can You Use Power Query In Power BI Or Excel To Write Data To A Data Source?
It is, technically, possible to use Power Query (in either Power BI or Excel) to write data to a data source; for example, here’s an old post I wrote showing how to run a UPDATE statement to update data in a table in SQL Server.
Business Central W1 Docker image with data
I’m using Docker quite regularly (well, if you find “pulling an image twice a day” is regular) .. and I have been using mostly these two repositories according my needs (for more info, look here):
“bcinsider.azurecr.io/bcsandbox-master” for the very latest version (the future release)
“microsoft/bcsandbox” for the current release