Forum Discussion
Bridge table (s)
Hello, I'm pulling in millions of rows across different, multiple tables. And according to whom is looking at the data, the visual slicers will filter accordingly. Each table has a lot of columns....
Hi AH-Ohio ,
for Power BI it is ideal to model according to the star schema: Understand star schema and the importance for Power BI - Power BI | Microsoft Docs
Power BI – Star schema or single table - SQLBI
I'm familiar with the star schema- which is somewhat of the approach I attempted the data hub prior to brining in the common Column tables. I attempted to put them in to one single table (which would have served as the "dimension table") ; however- due to size of data was unsuccessful. How can I accomplish this task in query (should I append every single common colum
table into one single column in one table and then build the relationships)?
