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!
You may try to refer to these document as below:
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.
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.
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.
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?
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.
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.