Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Best practices for working with star model?

I'm doing a migration from QlikView to Power BI and have found several difficulties   I am finding it very difficult to make a full charge only once my DW, I have 7 fact tables and more than 10 dim...
Need Help
achinm45's avatar
achinm45
Icon for Advocate IV rankAdvocate IV
10 years ago

Hi Anonymous ,

 

I have gone through your post and it seems you are using "Import" option in Connection String. This means that you are askign Power BI to do following :

1) Bring Data into Power BI from Sybase. That means data gets copied.

In my opinion, issue can occur because of Data limits in Power BI. Single Power BI file can not have data more than 250 MB.

 

Please do following :

1) Check total size of your tables. Are they more than 250 MB ? Try to see if it possible to minimize the data

2) For testing , you can also try to make mirror copy of these tables and just transfer few rows for month from original tables.

Then make reports from these mirrored tables. This will check both : size limits of Power BI and relationships too.

However, I dont think relationships shall be issue.

BR,

Achin

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi achinm45

     

    My application has 98 mb, but now that you talked about the 250mb limit was concerned for the well near future, will have to develop a BI where the fact table will have 2 gb, I have to think what to do when the burden of my application could improve performance after upgrading VPN driver and Sybase, but I have a call with the power bi support open on this issue, as I discover something I'll post here, I'll leave this open topic for now