Forum Discussion
Data storage architecture for Power BI - creating star schema directly in database?
Hello everyone! My question is a more database related one, but with the goal to improve the architecture of our current Power BI solution. Maybe someone with general IT knowledge can help out 🙂...
Hi Anonymous ,
I think currently your issue is large size of data from data source in Power BI Report with import connection mode. I suggest you to try Direct Query connection mode to connect to your database. I think you can create some Dim tables to create star schema in your data model. Then your connection mode will be converted to Mixed.
You may refer to this offical blog to learn more details about how to optimize Power BI Performance.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.