Forum Discussion
Central Dataset
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?
1 Reply
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
