Forum Discussion

SEMattis's avatar
SEMattis
Icon for Advocate III rankAdvocate III
6 years ago
Solved

Paginated Report using Power BI service Data Source

Hej!   I'm trying to build a paginated report using a data set that I have produced as part of an app recently released. I am trying to use the same logic used in two of our Matrix visualisations (...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    I think the issue is related to this calculations in Power BI Desktop.

     

    Best Regards,

    Giotto

v-gizhi-msft's avatar
v-gizhi-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi,

 

Do you have a calculation in Report Builder?

If so, please re-create it in dataset and pull the same to the Report Builder.

 

Best Regards,

Giotto

  • SEMattis's avatar
    SEMattis
    Icon for Advocate III rankAdvocate III
    6 years ago

    Hi,

    v-gizhi-msft 

     

    No I do not have a calculation that I have made in the report builder. I have on the other hand calculations that I have made in Power BI desktop that are part of the data set I'm using as the data source for the paginated report. 

     

    Could this be an issue?


    Regards,

     

    Mattis

    • v-gizhi-msft's avatar
      v-gizhi-msft
      Icon for Community Support rankCommunity Support
      6 years ago

      Hi,

       

      I think the issue is related to this calculations in Power BI Desktop.

       

      Best Regards,

      Giotto

      • SEMattis's avatar
        SEMattis
        Icon for Advocate III rankAdvocate III
        6 years ago

        Hej Giotto,

         

        I think you were absolutely right. I used DAX Studio to analyze my queries and used the Studio to develop a query resulting in a table which I then imported into Power BI report builder and then published the report to PowerBI Service and added it to my app. Works great and our endusers are very happy :). 

         

        Have a good rest of the week!

         

        //Matt