Error Star schema

[vitexo87]

I have several fact and dimension tables and need to load all in my application , however I am in trouble at the time of loading , and when you create the relationship between dimessões and facts , the only log that is displayed is " an unexpected error " already tried in various ways however without success, can work normally with these tables in QlikView but in no time I got the power bi , is there any limitation on the power bi regarding the amount of facts and dimensions to be used ?

[Nhallquist]

There shouldn't be alimitation on Rows.  Have you tried concatenating the fact tables into one table, then linking you Dimensions to that one table?  QV and PowerBI are not the same, even though they both claim to be in-memory.

[vitexo87]

as I concatenate the tables in power bi?

[Nhallquist]

You can concatenat them in the PowerBI script.  The other excercise I would go through is to eliminate unused fields.  I have run into this a couple of times and this is what I did.

1.  load 1 table at a time, start with all the dimension tables.  You should be able to load some, if not all of them, without any errors.  Once you get the error, the last table you loaded is the one with the issue.  Once you find that table, start by loading just a few columns at a time, until you find the columns that are causeing the error.  This is tedious process, but it really helps figure out which table(s) are at issue.

2.  Reduce your data by eliminating unwanted columns and rows.  While PowerBI may not have any ristrictions, your machine running the scripts do, they only have so much CPU and memory.  That could also be what is causing the issue.

I assume you are using the Desktop verion.  So something else to try would be to build the same app at App.Powerbi.com.  See if that makes a difference.