Forum Discussion
Power BI data sources/Architecture
We are rolling out Power BI at my company, and I have the unique opportunity to advise IT on how we should house/structure our data to work best with Power BI. We have a lot of data, so we need to...
"We have a lot of data, so we need to use either a live connection or a direct query." Not really. Power BI Premium can support data models far beyond 10GB size if you are willing to pay for a P3, P4 or P5 capacity
The new composite model allows you to switch from live connections to direct query, while at the same time allows you to create local clones of the data models, and to combine multiple data sources.
What is your company's position on using Dataverse? The one thing Power BI is definitely missing is a data stewardship module, so you would need to look into Dataverse, Purview, or other (including open source) data modeling tools to keep your company's data subjects under control.