Forum Discussion
Advocate IIIMultiple reports results to one major KPI table
Hi matemusic,
I'm afraid we can't create a report from several different reports / models. You can submit an idea here: power-bi-ideas. There may be two workarounds. One is yours. The other one is using an online Excel, which isn't perfect one.
1. Install "Microsoft Power BI Publisher for Excel".
2. Connect to the report, and PowerViot the target measures.
3. Create a summary table in a new sheet.
4. Upload this workbook into OneDrive.
5. In Power Service, "Get data" get the workbook from OneDrive as an Excel Online.
6. Everytime update the excel, then reload it in the Power BI Service, the KPI table would be updated.
Best Regards!
Dale
Microsoft EmployeeHi matemusic,
Using macro in Excel is a wonderful idea. I have encountered refreshing problem of excel several times. If you work it out, please share the code with me (and the community). I will try it too. Thank you in advanced.
Best Regards!
Dale
Advocate IIIIf we will use this method i will share the code. Currently there are questions about stability of using this method.
- v-jiascu-msft
Hi matemusic,
I think the only way to find out the stability is trying it in a environment similar to the production.
Best Regards!
Dale
- matemusic
Hi v-jiascu-msft,
i found this code on the reddit (https://www.reddit.com/r/excel/comments/3i6hf8/code_in_vba_to_automatically_save_a_file_every_15/):
'ThisWorkbook:
Private Sub Workbook_Open() Application.OnTime Now + TimeValue("00:00:10"), "SaveWb" End SubModule1:
Sub SaveWb() ThisWorkbook.Save Application.OnTime Now + TimeValue("00:02:00"), "SaveWb" End SubNow we wil testing connected Excel to 15 Datasets over night. I will report how it will go.
- v-jiascu-msft