Forum Discussion

matemusic's avatar
matemusic
Icon for Advocate III rankAdvocate III
9 years ago
Solved

Multiple reports results to one major KPI table

Hi all,   for our company we made about 15 reports for different topics (Revenue, Accuracy of the supplier, Accuracy to the buyer, Stock, Production success, Labor productivity and so on...). We us...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    9 years ago

    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

v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi matemusic,

 

Thank you very much for sharing. I am eager to know the result.

 

Best Regards!

Dale

matemusic's avatar
matemusic
Icon for Advocate III rankAdvocate III
9 years ago

Hi v-jiascu-msft.

 

I tested it. Problem is, that somethimes connection fails, so user has to click OK on warning message for each failed connection. After that user can refresh data manually with no problem (or can wait for next auto refresh). When refresh is running over night, there is no user to click OK, so refreshing process is stopped. That is a huge problem, which I dont't know how to resolve it.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi matemusic,

     

    Thanks again for sharing. I have tried to do it with Microsoft Flow. But it didn't work.

     

    Best Regards!

    Dale