03-20-2017 05:41 PM
Hi. I'm having a very strange issue.
I have a tabular database with financial information of two fiscal years, 2016 and 2017. This tabular database is the source of my PowerBI solution. Is not a live connection, as I'm manually refreshing the data as I created many DAX based measures on PBI side. There is one specific table from which I have exactly 28999 rows on my relational database (the source of the tabular), the tabular itself (verified browsing the data in Management Studio) but PBI is only importing 28639 rows.
I've tried deleting the tabular database, deploying it again, refreshing and have browsed the entire solutions for something. Nothing seems wrong. Even I've tried to import that same table with a different name but the same quantity of rows is coming. Is a Fact table the affected, and is partitioned by Fiscal Year. I've checked even the quantity of rows by partition in the Management Studio and all is ok. This difference in rows is causing to not having the same totals on both sides.
Do you guys have any idea of what can be wrong? Maybe I'm passing something important to check.
Thanks in advance for your help.
03-21-2017 05:11 PM