images

Click Click (Copy, Paste) and the Data is out there... The risks in PowerBI import mode (and the Solution)

PowerBI file usually contain data and metadata such as relationships, measures, calculated columns etc… When PowerBI file contain the data, it is super easy to use and it called import mode.
It bring the data to PowerBI from various of data sources to a tabular model that reside in the file and that when PowerBI can work fast and be interactive and easy to work with.

The benefits are very clear, but what are the risks?

Bring all the data to one file sound familiar.
It is similar, in a way to how MS Access works.
MS Access contain all the data and code in one big file.
PowerBI can reside in the cloud (PowerBI Services) but to change anything you need the file.
Problems starting with someone copy-paste or downloaded that file.
That is super easy to do. It’s just a file...
From that moment the company lose track of the data, it can go to finance department, marketing department, etc,
and can find it way out of the organisation in various of simple ways.
It became impossible to secure.

But again, the benefits of using PowerBI are very clear, so what to do?

Contact us for solutions.

images

Advance Premium Features in PowerBI

Wow! such a pleasure to use some of the most advance Premium Features of PowerBI.
I'm currently working on a Project for a Large Retail Company.
I was able to enable them to use the full capacity of the Technologies they already paying for.
When I turn on the Enhanced Compute Engine on a DataFlow I built and used Direct Query Mode, Magic start to happen.
The DataFlow then become a Tabular Cube which can be Queried using Direct Query!
All the PowerBI Reports can use it as a Single Source of Truth and the pbix file become just metadata.
When the DataFlow get refreshed all the PowerBI Reports are instantly up-to-date.
The DataFlow can also use Incremental refresh to speed up the refresh
Excel users can connect to the PowerBI Datasets and use the Tabular Cube. No more old fashion Multidimensional Cubes!

Are you ready for a better,

More robust business?