Excel 2013: Have 16,000 lines coming in - have found it will only pull it in 4,000 line chunks - how would you go about setting up 4 different odata connections in Power Query with ability to refresh all of them?
Also if editing of columns and filters after all the data is in - any way possible to setup a macro that would refresh all data connections and edit columns afterwards?
Thank You!
Power BI beginner
Also if editing of columns and filters after all the data is in - any way possible to setup a macro that would refresh all data connections and edit columns afterwards?
Thank You!
Power BI beginner
