how to link power BI report to excel

[Amardep1010]

Hi 

How we can link power BI report to Excel file with live data?

Please guide

[Omega · Accepted solution]

or you can create an SSRS report using Microsoft Report Builder, publish the report in Power BI Report Server and run the schedular from there. The report builder uses similar DAX functions used in Power BI. 

You can check the below link for tutorials on the same. 

Hope this helps 🙂 

https://docs.microsoft.com/en-us/sql/reporting-services/report-builder-tutorials?view=sql-server-201...

[Omega]

I don't think this is possible as you can't create a direct query connection with Excel. You can try the below:

•  Apply Ad-Hoc refresh or scheduled refresh.
• Move your data to SQL server or any dataset that access live connection or direct query. 

[Amardep1010]

Is there any way where i can export specific visulised table of that report to .csv every month? or specific date?

[v-cherch-msft]

Hi @Amardep1010

It seems there's no better way to do that. Here is the similar idea and you may vote for it. Below is a blog for your reference.

Export Power BI Desktop data to CSV Files

Regards,

Cherie