Export to Excel from Power BI Power Automate
It is extremely important to note the following critical aspects:
1) Export takes place exactly the filtered data.That is, the filters in Power BI have selected certain values.What the table shows is that we export, the exported data have to be dynamically dependent on the filters in Power BI.2) The Power BI table can be more than 1000 lines.I do not ban the algorithm when the export goes to CSV, and then in Power Automate this CSV file is converted to Excel.Or any other algorithms you propose.The main thing is that the output should be Excel.
He tried to solve the problem on his own.The main problem is to make such exports dynamic (see.by p.1).At the moment the most approached to the result by using the "Run against a query" step, which takes as the input parameter of the data from the Performance Analyzer in Power BI.There is a video that will completely solve my problem: https://www.youtube.com/watch?v=poMUTMSMccs
But with the realization of the algorithm from the video there are constantly some technical problems.A test example in a fixed (only for your convenience, test decisions and better understand the task).The price is agreed.
Applications 1
Client's review of cooperation with Vitaliia L.
Export to Excel from Power BI Power AutomateThe project is closed by my unilateral decision (with full payment of work) due to the absence of a response to the execution within 6 days. It is a neutral reaction. The project itself is complex, so clear deadlines were not established, but the recommended deadline was established in two weeks without indication of reasons. Additional clear deadline - which I left for 5 days before the completion of the new deadline was left without a response, while I was open to the discussion and another date and gave it clear to understand. There were intermediate results (if you believe the words of the execution), but the project within reasonable deadlines (full two weeks) was not brought to the end. The executive rarely comes to contact - the feedback can be expected to be up to 3 full days.
-
199 2 0 Good morning, I set up a button like that. So I can try to take it.
I don’t give any warranty, but pay only after completion. So if you don’t get out, you won’t lose anything.
Current freelance projects in the category Databases & SQL
Resolve the loading issue on the PrestaShop website hostingThe website requires more and more resources each month. The host's response: During the server check, increased load from the MySQL database server was recorded. At times of the 500 error, the MySQL process uses a significant portion of CPU resources, which can lead to unstable… PHP, Databases & SQL ∙ 3 hours 29 minutes back ∙ 16 proposals |
Setting up a backup system and optimizing server infrastructureObjective of the work: Ensure reliable data storage for the CRM system and application by implementing an automated backup system, as well as carry out a series of server improvements to enhance the stability, security, and performance of the infrastructure. DevOps, Databases & SQL ∙ 4 hours 59 minutes back ∙ 16 proposals |
PIM system
225 USD
A PIM system needs to be created. The number of products is several million. There are several suppliers providing data in different formats: csv, xml, API. The data is limited, and often it is necessary to find product characteristics from other sources and supplement them. A… Databases & SQL, Web Programming ∙ 6 hours 56 minutes back ∙ 33 proposals |
Integration of BAS Shveyka 8
225 USD
Good day, it is necessary to integrate BAS Shveyka 8, connect the website and CRM Sales Drive, set up reports and other data. Databases & SQL ∙ 8 hours 2 minutes back ∙ 8 proposals |
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 1 day 2 hours back ∙ 16 proposals |