Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |