Parameter Based First x Rows

[Anonymous]

Hi all,

I'm having signicant issues publishing a dataset to service, it takes FOREVER, if it publishes at all. The data set is fairly large at 700mb and I think that is the issue. There is no associated charts etc, the assocaited report is blank.

Through research I have found that one potential work around is to:

1. Go to Power Query
2. Select Top x Rows
3. Apply & Close
4. Go to Power Query
5. Remove Top x Rows condition
6. Close (Don't Apply)
7. Save
8. Publish File
9. Reload on Service

This seems logical, by reducing the size of the file I can actually publish it........

Now, my challenge is that I have quite a number of tables in my model (25+) and I don't want to have to do this to every table, each and every time I make a change or whatever. 

So I am looking for a solution where I can add some parameterized value script into the Advanced Script for each table, that way I can set the value across all tables in one action for example:

1. Open Power Query
2. Set Parameter to 1 (row)
3. Apply and Close
4. Open Power Query 
5. Set Parameter to 99999999999999
6. Close  (Don't Apply)
7. Publish File
8. Reload on Service

I can't seem to find any documentation on writing this expression, just examples of using the GUI to limit the rows. 

Any 🙂

[Anonymous]

Sorry!  It's:

https://blog.crossjoin.co.uk/

---Nate

[Anonymous]

Sounds like you are trying to do what @cwebb describes on crossjoin.co.uk in his excellent article about using Table.View to grab just the first row, figure out the schema, and then process the rest of the query. You should check it out.

--Nate

[Anonymous]

I followed the link you provided however it appears that the domain name is for sale now - could you provide futher details?