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,

 

Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.

 

Best Regards!
Dale

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

Hey, sory..

 

Unfortunately, my problem is not to create a table with different measures, but to get measures from several different reports / models into one common KPI table.

 

The final result I'm looking for is a dashboard that contains one table with multiple KPI data instead of several KPI visualizations.

 

For now we need to build one huge model (instead of using existing, smaller models) that is too large and too complex for maintenance and normal operation.

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    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

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

      Thank you v-jiascu-msft, that is similar solution we are looking for.

      Big problem here is refreshing. Maybe we wil try to use macro in Excel, which will refresh data every day.

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

        Hi 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