I'm new to Data visualization and currently I'm migrating couple of dashboards from tableau to powerBi. Both tableau and powerBi imports data from sql server. Which is the best way to create an efficient data model in powerBi while taking into consideration of views from tableau?
0
votes
your question is too wide to answer. what challenge did you faced during data model? If you have data coming from different tables, it is bound to have compled data model. You will need to test this with your data loading into powerbi and response of you reports.
- AnkUser
Also search for "Tabular Model Performance" a lot of the relevant material was written for Analysis Services, but is applicable to Power BI, as they use the same Tabular Modeling Engine. bing.com/… And watch this video: sqlbi.com/tv/…
- David Browne - Microsoft
1 Answers
0
votes
The best way to create a data model in Power BI is to create a Star Schema. If you are not familiar with a Star Schema do some research on the web. It will be something that it is well worth your while to learn. You may end up having to use Power Query to deal with tables from both sources that hold similar data.
