Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |