web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Getting only date from...
Power Automate
Unanswered

Getting only date from PBI report using run a query against a dataset

(0) ShareShare
ReportReport
Posted on by 16

Hello,

I've got a flow below:

Jakub_Kujawa_0-1682419459691.png

Which retrieves information about refreshing the power Bi report and saves the result on Sharepoint:

Jakub_Kujawa_1-1682419592746.png


"File name" is an output from "Create CSV table" step and it is saving as "[report name] +  refreshed date".
I would like to download only the date from this refresh without the report name, so that I can compare it with the one written in the "file change time" column.

 

Categories:
I have the same question (0)
  • lbendlin Profile Picture
    8,474 Super User 2025 Season 2 on at
    Re: Getting only date from PBI report using run a query against a dataset

    That's the column name, not the report name (there is no report).  

    Use Select to remap the name as needed.

  • Jakub_Kujawa Profile Picture
    16 on at
    Re: Getting only date from PBI report using run a query against a dataset

    @lbendlin can you describe how to do it please?

  • lbendlin Profile Picture
    8,474 Super User 2025 Season 2 on at
    Re: Getting only date from PBI report using run a query against a dataset

    After the Power BI query run a Select step against the First Table Rows.  Or you can set a variable to the value of the column in the first row.

     

    If you post the raw output of the Power BI query I can show you the exact steps.

  • Jakub_Kujawa Profile Picture
    16 on at
    Re: Getting only date from PBI report using run a query against a dataset

    This one?

    [
      {
        "[Report name]""12-06-2023 06:15"
      }
    ]

    Jakub_Kujawa_0-1686577746767.png

     

  • lbendlin Profile Picture
    8,474 Super User 2025 Season 2 on at
    Re: Getting only date from PBI report using run a query against a dataset

    lbendlin_1-1686579377210.png

     

    lbendlin_0-1686579336257.png

     

  • Jakub_Kujawa Profile Picture
    16 on at
    Re: Getting only date from PBI report using run a query against a dataset

    i tried this but this refresh is variable so i need this output to be input for initialize variable because every morning "run a query against a dataset" has a new refreshed date

  • lbendlin Profile Picture
    8,474 Super User 2025 Season 2 on at
    Re: Getting only date from PBI report using run a query against a dataset

    yes, swap my first step for your DAX query.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard