cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

 

Hello Expert,

 i think below mentioend are the steps which i needs to excute it

4. Push the Json Document to your Flow Web URL.

5. Convert the Webcall Response

 

Shree

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

.

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Hello Expert,

could you help me with steps for this

4. Push the Json Document to your Flow Web URL.

5. Convert the Webcall Response

 

Shree

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Hello  @mwegener 

 

Can you help me with third step please

 

Shree

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Hi @Giant ,

 

Could you post a few screenshots of your current steps?

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Hi @mwegener 

 

I am trying the generate the url using below mentioned code

Error :Enter valid JSON

let
Source = #"Tracker – SAP",
ToArray = Table.ToRecords(Source),
ToJsonBinary = Json.FromValue(ToArray),

[Content = ToJsonBinary]),
LinesFromBinary = Lines.FromBinary(WebCall)
in
LinesFromBinaryerror.png

 

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Hi @Giant ,

 

start with this and post a screenshot

 

Just create a Flow whose trigger is a “When a HTTP request is received” (no further inputs in that step) and add a “Compose”-action with the Body-element in it. Then save the Flow and copy the generated URL:

1_Setup_Webservice

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Hi @mwegener ,

 

thanks for the response,

 

Parse the result and load this query to the datamodel (this is very important, because otherwise the WebCall wouldn’t be made if the dataset is refreshed!):

  • row 8: Lines.FromBinary(<WebCallFromAbove>)

I think it is power bi desktop datamodel edit query option ..is it correct?

 

Shree

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Hi @Giant ,

 

did you receive a URL?
Yes, the next steps are at Power BI Desktop.
Can you do that steps and post a screenshot?

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Hi @mwegener ,

 

here is the screenshots but i am getting after the step,

Error Message

Formula.Firewall: Query '10 millions (2)' (step 'LinesFromBinary') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.10millions.png

 

 

Error

Error1.png

 

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Hi @mwegener 

 

I corrected this step,No reference table required, can do it with original table

 

no reference table req.png

 

Shree

 

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Hi @Giant ,

 

has data arrived in flow?

 

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Gives error in 3rd step

create csv.png

 

Entered correct value

 

Create csv1.png

 

 

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Could you post a screenshot from your 2nd step?

 

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

 

Able to download the file...1st step is successfully completed till download data to onedrive but only question is in mind for data refresh ..how it will pull the data from workspace or desktop..

Test.png

 

i did datasets refresh automation as below and it is essential to refresh the data 

https://powerbi.microsoft.com/en-us/blog/refresh-your-power-bi-dataset-using-microsoft-flow/

 

Shree

 

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

I think you can use the normal Power BI Service Data refresh schedule.

 

https://docs.microsoft.com/en-us/power-bi/refresh-data#setting-a-refresh-schedule

 

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

 

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Hi @mwegener 

 

if i publish the same pbis file to the workspace or say myworkspace and schedule data refresh from there as mentioned in your link and then if i trigger flows further export data will it take it from workspace or power bi desktopworkspace.png

 

Shree

 

 

 

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Workspace (Power BI Service)
Power BI Desktop is only for the development and you have no connection from the internet (flow) to your Power BI Desktop.

 

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Hi @mwegener ,

 

CSV. file is created in JSON format how it will convert it 

 

[{"Column1":"1"}{"Column1":"2"}{"Column1":"3"}{"Column1":"4"}

 

convert in columns and rows like mentioned below in csv file

column1

1

2

3

 

Shree

 

Highlighted
Helper II
Helper II

Re: Power BI table data export in csv to email using Microsoft Flow

Could you post a screenshot from your 2nd Flow step?

 

Modify the “Compose”-step to parse out the table from the JSON like this:

1_FlowCompose

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (6,842)