Forum Discussion
apentyala
Helper II
Helper IIHow 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?
2 Replies
- Greg_Deckler
Community Champion
If it is SQL, you can enter SQL code by going to Advanced when you connect.- apentyala
I am connecting to Teradata but I have multiple tables. The advanced table works for a single table, right?
