Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Advice needed - enterprise datasets

Hi all,   I am after some advice / best practice done in your respective organizations.   I work for a mining company with various systems of records (historian with process data from Honeywell, ...
Need Help
collinq's avatar
collinq
Super User
6 years ago

Hi Anonymous ,

 

The question about "where to build" is ongoing and is debated constantly.  To me, it goes to the ability of the organization and the ongoing sustainability of the organization to maintain that data.

 

I prefer the Power BI way (having been a SQL Admin in the past).  I do exactly what you indicate.  I create the data model in Power BI as this gives me the most freedom and other folks (not just SQL experts and people with SQL permissions) can use it as per my security settings.

 

For the large dataset, we can then use incremental refresh in Power BI.

 

This allows me to have the security, data model, refreshes and ongoing maintenance in one place.

 

But, as I stated, some folks will have a different opinion.  We have just found that if yo uwant to make a change, you have to get onto the SQL folks' radar and often have to make a sacrifice to the IT guru to get a change made.

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thanks collinq 

 

One question: how do you handle someone needing to combine two data sources in a single pbi file, both of which living in two different datasets? THis is the biggest roadblock we have at the moment as well as wanting to add calculated columns and not being able to.