cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Aishwar04 Regular Visitor
Regular Visitor

Connect Power BI to an excel front end

Hi Team I have come across a requirement, say Power BI needs to connect to an excel interface where say for example a button is clicked in the excel and a report is generated. How can we get this generated report into the Power BI dataset?

 

Quick help will be appreciated!

 

8 REPLIES 8
Community Support Team
Community Support Team

Re: Connect Power BI to an excel front end

HI, @Aishwar04 

You may try to refer to these document as below:

https://docs.microsoft.com/en-us/power-bi/publisher-for-excel

https://docs.microsoft.com/en-us/power-bi/service-publish-from-excel

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Aishwar04 Regular Visitor
Regular Visitor

Re: Connect Power BI to an excel front end

Hi, @v-lili6-msft

Thanks for your reply.

But I am looking at a situation, where a user opens a report in Power BI, there should be a mechanism that runs everytime and fetches data from that excel interface by feeding some parameters in the excel and that excel data is loaded into Power BI.

 

Community Support Team
Community Support Team

Re: Connect Power BI to an excel front end

hi, @Aishwar04 

After my test, I'm afraid it couldn't achieve in Power BI for now.

And you could post your new idea in Power BI ideas and make this feature coming sooner.

 

 

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Aishwar04 Regular Visitor
Regular Visitor

Re: Connect Power BI to an excel front end

Hi,@v-lili6-msft

Thanks for your reply!

Can Customer Connectors prove to be helpful in this case?

Is there any other workaround? 

Community Support Team
Community Support Team

Re: Connect Power BI to an excel front end

hi, @Aishwar04 

If you want that when a user opens a report in Power BI, then he wants to add new data from excel into Power BI dataset?

Currently, it couldn't achieve for now.

you could download the pbix file then get data from excel and adjust report and republish it to power bi service.

or add the new data into datasource and refresh report manually.

 

Best Regards,

Lin

 

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Aishwar04 Regular Visitor
Regular Visitor

Re: Connect Power BI to an excel front end

Hi,@v-lili6-msft

Thanks for your reply.

Also, its not just that we download the .pbix file, refresh it and republish it.

When different users access the report then they should be able to pass in different parameters from Power BI which should go and hit the excel interface and get that report generated from the interface based on the parameters fed by a user and load the data into Power BI.

Any workaround using R or Python or Power BI APIs?

Community Support Team
Community Support Team

Re: Connect Power BI to an excel front end

hi, @Aishwar04 

According to my knowledge, I'm afraid it is difficult to achieve in Power BI for now.

for different users, you could use RLS to get the different report, but why load the data into Power BI in this way.

Usually, for the dataset, we could set refresh to change it.

 

Best Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Aishwar04 Regular Visitor
Regular Visitor

Re: Connect Power BI to an excel front end

Hi, v-lili6-msft

We need to load data in such a way because this data is real time say example stocks data which changes every second so users just feed in the date from Power BI it hits the excel interface carries out some calculations and generates the report and then load it into Power BI. At the same time different users can feed different dates to get the report out of the excel interface and when it is loaded into Power BI we can visualise data.