Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all,
Is there any way to make restrictions, so that I will be able to load ONLY the tables that is required, from the data source.
I don't really understand your question.
When you connect to your data source you manually select which tables you need.
The problem is, the dataset which I have has more than 10000 tables.
When Previewing, it is showing only 10000 tables.
With tables you mean records right? And that's normal, preview only shows a subset of your data. Once you load it, it should contain however many records you have.
Yeah, records. When I import dataset from SQL Server, the navigator shows only 10000 records. But i have more than that.
Once you physically import them, it'll be more than that figure. Try it.
Preview does literally what it says... give you a preview.
In SQL terms it just does:
Select top 100000 (*) from YourTable
Importing it does:
Select * from YourTable
EDIT: If you're LITERALLY talking about having 100000 tables (and not records) then just import with a SQL statement instead of using the navigator.
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |