Forum Discussion

apentyala's avatar
apentyala
Helper II
6 years ago

How to restrict data while importing into desktop?

I have 3 dimensions and 1 fact table with 10Millions records, when I imported 10M records into the desktop it is not responding and running very slow. Is there any way to restrict data before importing into pbix file?

 

One more question, when I upload the PBIX file into report server(on-primes) users want to see 10M records based on their search criteria?

power bi
Power BI Report Server

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    If it is SQL, you can enter SQL code by going to Advanced when you connect.
    • apentyala's avatar
      apentyala
      Helper II
      6 years ago

      I am connecting to Teradata but I have multiple tables. The advanced table works for a single table, right?