Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
HI, @Anonymous
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
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.
hi, @Anonymous
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
Hi,@v-lili6-msft
Thanks for your reply!
Can Customer Connectors prove to be helpful in this case?
Is there any other workaround?
hi, @Anonymous
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
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?
hi, @Anonymous
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
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.
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |