iqy file I got by going to the SharePoint list and clicking the Export to excel button then just saved it to a document library then point to the file. iqy file which I have stored in a document library which then displays all of the contents in the excel file. Then I have a button that when pressed first deletes all of the entries in the SharePoint list, writes the collection with the latest values up to the SharePoint list then downloads an. I get the data that I need from the DB into a collection which has the same field names as that in the SharePoint list (this is just a throw away list to store the data temporarily) so its easy to push to ex:ĬlearCollect(CollectionName, ShowColumns('.', "Field1", "Field2", "Field3", "Field4" )) I had a similar situation where the data is stored in a SQL DB. let me know so we can bump this into their suggested enhacements list. If this is functionality the development team over there hasn't thought of I would be shocked.
#Power bi download data table how to
I have hard coded this in the past with visual studio, just not sure how to get started here.Īny thoughts or exacmples would be appriciated. Just a simple method to export what is in the data table into a spreadhseet for download. I am sure this is one of the most common use cases.
I am also not trying to email anyone, or attach anything to an email or get involved with flow or any other 3rd party tools. I am aware that if the powerapps data table in question is using an excel spreadsheet as the data source, then users can just work between that excel file and powerapps. It creates 3 files, none of which are traditional cvs, excel types of grid structures with columns and rows.
#Power bi download data table zip
I know you have an export control in powerapss, and I know you can set this to look at various data sources and it will initiate a zip drive download. The user clicks this button, and the data table exports it's rows / columns into a zip file, or an excel file and user downloads it from here. So there is a button on the screen that says "Export to Excel". In the Power Query Editor window we have 4 common options. When you click on this option it will take you to the Power Query Editor window, with uploaded data. Go to the HOME tab and click on Edit Queries. The user looks on the screen and sees the data in the powerapps data table, then wants to get a copy of what he / she sees downloaded to excel. So, all the data transformation is done by using Query Editor in Power BI. The powerapps data table is using a SQL Server view / table as the data source.
I suppose I should clarify the use cas a little more. Hi Thanks for the quick feedback everyone.