Central Dataset

[Anonymous]

Looking for advice on how you handle connecting your various datasets together?

We maintain our datasets seperately, and then connect them all to a single central dataset, all via directquery. 

On the front end, it runs fine, but when we're working on the central dataset, its ridiculously slow, and can take a day to add a couple of relationships and a couple of measures. Are there any tricks to speed things up (we've started using tabular for measures which is helping a lot)? Or is there a better way to connect all of an Orgs data up together?

[JoeBarry]

Hi @Anonymous 

Maybe this article will help? https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-troubleshoot 

I would also import the columns that you actually need. Maybe also aggregating the data before importing into Power BI if it is really large dataset.

Thanks

Joe