Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
I have Query1 which has imported data from SQL server table which has 2.3M records with 2 columns.
IpAddress_Table(Query1):
IpAddress | IpAddress_Decimal |
Query2 is the CSV file which has 5 columns which as 25K records:
Query2:
Column1 | Column2 | Column3 | Host_Min_Decimal | Host_Max_Decimal |
I have added one new custom column in Query 2 using below formula, this column is giving the IpAddress value from Query1 which is in the range of Host_Min_Decimal and Host_Max Decimal.
Table.SelectRows(IpAddress_Table, (IpAddress_Table) => IpAddress_Table[IpAddress_Decimal]>=[Host_Min_Decimal] and IpAddress_Table[IpAddress_Decimal]<=[Host_Max_Decimal])[IpAddress]
The problem is while saving the data model it is taking indefinate time due to which i am unable to save it.
Please let me know how to resolve this issue.
Regards,
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.