Forum Discussion
Upload Big Files
I'm thinking that perhaps you could use a Parameter for this. So, my thinking is that you create a parameter and set it equal to something like 1. In your query. Add a Keep Rows to your query and set it to something like top 1000 let's say. In your query, check the parameter and if it is 1, then continue on. Otherwise, skip the Keep Rows step essentially so that you return the full amount of data. So, in your PBIX in the Desktop, set the query to 1, refresh the data. Then set the current value of the parameter to something else, save your PBIX, upload the PBIX and then refresh from the Service.
I'm thinking that perhaps you could use a Parameter for this. So, my thinking is that you create a parameter and set it equal to something like 1. In your query. Add a Keep Rows to your query and set it to something like top 1000 let's say. In your query, check the parameter and if it is 1, then continue on. Otherwise, skip the Keep Rows step essentially so that you return the full amount of data. So, in your PBIX in the Desktop, set the query to 1, refresh the data. Then set the current value of the parameter to something else, save your PBIX, upload the PBIX and then refresh from the Service.
That worked!
Thanks 🙂