Capturing data changes

[smpa01]

Hello experts,

I have built a report by consolidating several data sources. This report is refreshed on daily basis and I need to capture the changes on a dily basis.

In order to that,I need to force Power BI to email me the excel report for self-archiving on a daily basis which in turn becomes the running data source for succeeding comparisons/reports (kind of like a running total calculation).

The way to force power bi to email an excel is by utilizing power bi report builder. Unfortunately, paginated reports are disabled by my organisation admin.

My question is there any other way (e.g. by utilizing R script) for me to force power bi to email an excel attachment of my report?

Thank you in advance.

[mwegener]

Hi @smpa01 ,

check out this blog post from @ImkeF .

https://www.thebiccountant.com/2019/04/01/export-data-from-power-bi-using-microsoft-flow/

[smpa01]

@mwegener thanks but don't have power automate, so can't use it. Looking for a R/Pyhton solution if possible.

[mwegener]

Hi @smpa01 ,

@ImkeF  has a solution here too 😉

https://www.thebiccountant.com/2018/12/29/export-data-from-power-bi-to-csv-using-python/

[smpa01]

@ImkeF I want to run a similar solution from Power BI service. The method that you discussed here can export a dataframe to the local drive.

In order for me to adapt this to my scenario I was wondering if it is possible

to

run a pythin script in power bi service

which

would export the dataframe in csv/excel

and

email (as unlike power bi desktop the script would not find my local drive when run in service)

or

send the output to an office 365 shareporint folder

Thank you in advance.

[ImkeF]

Hi @smpa01 ,

haven't tried that yet.

[smpa01]

@mwegener thanks I will come back to you on this soon.