Forum Discussion

amir_tohidi's avatar
amir_tohidi
Advocate I
10 years ago

Design advice needed

Hello,   Being new to Power BI, I am not sure what the optimal design for the following problem is. Any thoughts/ideas would be appreciated.   I would like to create a business user friendly data...
Need Help
amir_tohidi's avatar
amir_tohidi
Advocate I
10 years ago

asocorro - Only the FraudCodes data is in Excel. Everything else is in SQL Server. My problem is the large amount of SQL Server data that I need to process.

 

silolondon - I can't roll up the account transactions because our Financial crime team want to anlyses each and every single transaction in 1 half of 2015.

 

I am using 64 bit Power BI which I thought can handle large number of rows. Is that not the case?

 

 

achinm45's avatar
achinm45
Advocate IV
10 years ago

Hi amir_tohidi,

 

I think asocorro has suggested a nice way.

Since there are large nuymber of records in transaction table, it may be difficult to process the data in native connection mode  (Import mode ) for power BI.

There is another connection mode called "Direct Query" which does not load data into power BI but just facilitates visualisation.

Processing happens at back end.

Since you have SQL server, import excel data in SQL Server.

Then Connect to SQL Server and all other tables with Direct Query.

This will help you

  • amir_tohidi's avatar
    amir_tohidi
    Advocate I
    10 years ago

    Hi achinm45,

     

    I am using DirectQuery already as I din't want to load so many rows into Power BI.

     

     

     

    Hereis the data model (FraudCodes hasn't been added yet)

     

     

    Finally, here is the error: