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. ...
JoeBarry
Solution Sage
Solution SageHi 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