Directly Query a Power BI Dataset Using Power Automate and Save it to Excel in SharePoint

[@thatpinksoul]

This was very helpful. Thankyou so much.

[@tw-waytek]

Hello @thatpinksoul, thanks for your positive feedback and so happy I was able help you out.

[@victoriademkina8681]

An awesome solution, thank you so much!!!

[@tw-waytek]

Thanks @victoriademkina8681 for your positive comment, I'm glad I was able to help!

[@mijailhurtadovillegas1480]

it worked perfectly!! thanks a lot!!!!!!

[@tw-waytek]

Hello @mijailhurtadovillegas1480, that's awesome, great job!!

[@saakshimankar6215]

Can we apply a dynamic filter in this flow on our datset ?

[@tw-waytek]

Hello @saakshimankar6215, great question, thanks for reaching out, so if you wanted a filtered dataset, I would recommend creating a report for each filter you'd like to run since they are static, the other option would be to filter the entire dataset from the Excel file. I hope this helps, if not feel free to reach out to me at www.tw-waytek.com/contact-me/.

[@anujpoddar14]

The Select operations results into null values, whereas if I directly Create CSV table from the output, its working fine but the only challenge is the column name are in square brackets

[@tw-waytek]

Hello @anujpoddar14, thanks for reaching out, I'm not able to successfully replicate the way you are doing it. Can you send me a screen shot or two with the way your flow is setup. You can reach me at this link: www.tw-waytek.com/contact-me/

[@mauvenegas94]

Hey man , all works but whe the data is copied to the excel file , the headers are wrong. It leaves blanks rows equally to the amount of columns in the csv table and then paste the data. Any ideas ?

[@tw-waytek]

Hello @mauvenegas94, thanks for reaching out, can you share a screen shot of each action with me as well as the final excel file from the link below, this will give me a better idea of how to troubleshoot the issue: www.tw-waytek.com/contact-me/

[@sohaibnajam1161]

the flow run is failing at the run scripts bad gateway after 2 retries timeout

[@tw-waytek]

Hello @sohaibnajam1161, thanks for sharing, can you send me a screen show of your flow along with the error output, you can reach me here: www.tw-waytek.com/contact-me/

[@SufyanArif]

Hi Tyler, Your tutorial is awesome, covers all aspects but I'm getting error at run script step, why its failing? How can I share picture with you, I m not able to send you msg at your website contact page .

[@tw-waytek]

Hello @SufyanArif, thanks for reaching out and hitting me up on LinkedIn. I'm glad to have been able to help you out with your issue. Much success and reach out anytime.

[@SufyanArif]

@@tw-waytek Thanks much for your help, I was able to do what I wanted.

[@seangeorge6423]

Hi there! I've reached out to you via your website with the error message that I'm getting when trying to replicate your flow. Can you please help me here! Thank you so much!!

[@tw-waytek]

Hello @seangeorge6423 , thanks for reaching out, I received your request and will review. Stay tuned for a response.