Refreshing multiple files with single authentication
One dataset can contain queries from multiple data (CSV) files stored on the same OneDrive for Business account. On scheduling data refresh you need to log in for every single data file, not just once for the whole ODfB storage account. Would it be possible to accomplish this with a single...
GetData: Support SharePoint.Contents () data source
Selecting Get Data / SharePoint List creates a data source using SharePoint.Tables () , which gives you only the site information, but not the document contents. One can use the Advanced Editor and change it to SharePoint.Contents () . Then you can use a Navigate step to access any file (for e...
Error bars
We often have additional statistical information on our data points, like min/max, standard deviation (error), percentiles, etc. It would be nice to be able to render at least error bars showing the confidence interval for our data points. Standard deviation could be provided on a separate ...