How can we get original theme back?

I thought the keywords RangeStart and RangeEnd were used for incremental refresh.

Same issue I am getting when I am getting the data from API through ODBC can it be done through it?

let Source = Odbc.DataSource("dsn=TestDWH_Appointment", [HierarchicalNavigation=true]), DATA_Schema = Source{[Name="DATA",Kind="Schema"]}[Data], result_View = DATA_Schema{[Name="result",Kind="View"]}[Data], #"Filtered Rows" = Table.SelectRows(result_View, each [appointmentDate] >= RangeStart and [appointmentDate] <= RangeEnd) in #"Filtered Rows" Sir this is my code i can see native query till Navigation but when i filter it do not show

Can you export a matrix table data as csv?

I'm getting error as below when triggering manully and when go back to the report the run option is not enabled. can some suggest on this. please ' The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: entity.'.

This is EXACTLY what I've been trying to do for days. You sir, are a GENIUS!

What if you don't want a button? How would you handle a monthly set day of month refresh since Power BI doesn't allow this? I want to just use refresh dataset from power automate, and then schedule it on 7th day of the month

Thank You Sir!

Thank you so much for this video. I was able to achieve what I was looking for.

The flow is working and I am getting the output as expected, the only issue is I am getting multiple emails after triggering the flow.

Thanks

Brilliant, thanks!

It's a video which is really underrated! May you be blessed!

For some reasons, it didn’t work for me, I was only able to see “Microsoft Power Automate” nothing else

Thank You for the video. Does it work when Power BI on my computer is closed? How can I make it work out of access to my computer but refresh it online?

What if I have more than 3 datasets? Can we get items from share point list and loop through?

Nice video. Thank you for your explanation!

Very well explained Shahab!

I have already gone through all the shamanic rites, dancing with a tambourine.... It didn't work until I changed the names of the parameters to RangeStart and RangeEnd. It's just awesome:) So much searching and such a stupid solution.....

Great explanation. Thank you

Thank you, Persian John Lovitz

will this work for end users with viewing access on the workspace, and free license only?

Great video! Any idea how do I make this with a schedule cloud flow and not a click button? Im not able to get the CSV in the format of a table (only as a one-line output inside the CSV file) .In my case, it is sending an email but I want to send the output table as a CSV file... thanks!

one of the best and easiest ways of explaining it ...specially it is best for new users and those who have 0 knowledge of power BI, your explanation is the best in youtube as i have seen many videos but they don't tell you exactly as you explained....many thanks for your good job..keep it up and we look forward for other best videos

how about xlsx format?

Interested in knowing if you were able to do this in Power BI Service? Or were you able to do it at all?

Do we need to combine this solution with: Value.NativeQuery(Source, "SELECT * TABLE WHERE filter_for_RangeStart_and_RangeEnd ", null, [EnableFolding = true]) to have query folding working?

Does it work for Amazon Redshift?

When I click on the button, why am I getting four emails at the same time even though I clicked once on the button? Can you please suggest. thanks

Thanks for this amazing tutorial. I need one help, how we can send multiple csv files or tables in single emails

best tutorial! thanks for saving my life haha!

Sir, thanks for the video, does this also work for table visuals created with parameters in power bi, for example, the first 3 columns in table visual is chosen dynamically from parameter and rest 2 columns are totals

Sir, thanks for the video, does this also work for tabke visuals created with parameters in power bi, for example, the first 3 columns in table visual is chosen dynamically from parameter and rest 2 columns are totals

crystal clear explanation, thank you for sharing

Thats Great. Another concept cleared.

Thanks Shahab. That was greate!

what if the Power Automate fails with a 5 min refresh and we have to cancel the dataset refresh in Power BI service. Does Power Automate has a flow or action to cancel out a data refresh? I would like to add this action if my data refresh fails and I can to cancel the data refresh on the Power BI side until the next scheduled API call from Power Automate.

Wow nice video

Hi, thanks for detailed video. i am encountering a problem here. i am getting emails for each record, received 26 emails as i have 26 rows in table. is there a way we can avoid this?

Thank You Sir

Thanks for making this simple without a lot of fluff!

"Promosm" 🌹

Great video, thank you

Hi , in my case date is not updating if I do refresh via web portal but in power BI desktop it does , any solution

I followed the steps in the advanced editor to do query folding however, mine didn't work. Any guesses why its not working. Data source is sql server.

nicely explained, makes it clear to understand. thanks

Hi! Great lesson. How would I got about creating a dynamic filter for the content based on a different table of contacts coming from SharePoint?

Than you very much for your tutorial.One question please: How could you assign a subject to the email that depends on a data value in Power BI? I am referring, for example, to a value by which we have previously filtered in Power BI

Why is date format types not appearing on dynamic content?