Forum Discussion

Kmanikanta's avatar
Kmanikanta
Regular Visitor
1 year ago
Solved

To know about data validation techniques

Hi all, I am working on a power bi project where I need to develop multiple reports that has visuals like table, slicers kpis. WI am validating the data manually in the reports as of now like how man...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Kmanikanta ,

     

    I recommend that you use Power Automate to export report to PDF or create report subscription. For report subscription, you can create subscription directly in the Service after publishing report to the Service. Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft Learn

    Licenses: Power Automate license, Power BI Pro or PPU

     

    Here's my test of creating a flow export report for your reference.

    Original data.

    Step1. Create measures for statistics.

    Count = CALCULATE(COUNTROWS('Table'),ALL('Table'),'Table'[ID]=MAX('Table'[ID]))

    Total = COUNTROWS(ALL('Table'))

    Step2. Save and Publish report to Service.

    Step3. Create Flow.

     

     

     

    Best regards,

    Mengmeng Li

danextian's avatar
danextian
Super User
1 year ago

hI Kmanikanta 

 

DAX has some useful functions which some can be used in a calculated table, some within the DAX query view.

For example COLUMNSTATISTICS() can return the list of columns in each table, the min and max values as well as the cardinality. INFO.VIEW functions can return calculated tables.