@@JonJLevesque Is there a way to automate sql database -> Power Bi Desktop -> Power Bi Service in end-to-end fashion without having to open any app at all??? For example, use Python to do so?
Great video. Looking for some education on how to import excel into SQL Server using flow. Tried various things with no real guidance and not having any luck. Know of any videos or training I could cut my teeth on? Thx
Excellent movie, I'm big fan of SQL Server, Power Query and Microsoft Flow. I hope the action of Open Transaction/Commit/Rollback to Microsoft Flow for automate business workflow 🐱🏍🐱🏍🐱🏍
Does the power automate per user plan include the SQL connector? I am currently using a plan 2 trial version, and need to move to a paid license, but not sure which license type has the SQL connector…
My issue is with the triggers. The trigger concerning when an item is created works fine. When I connect to the database I can find all the table names in the database through the dynamic content. If I try using the trigger when an item is modified I can connect to the database, but nothing is displayed in the table name field through dynamic content. If I try using a custom value (the table name I am trying to use) nothing happens when I modify something in the SQL table. Any hints on what might be the issue?
Very cool, I am a old ECM guy but new to Flow. I see a couple of applications, but, I could be all wet. The first application is retrieving data from SQL and passing it to metadata in a SharePoint library to retrieve documents. The second is the reverse of that and passing metadata that was captured in SharePoint, probably from a document, to a SQL database.
Hi Guys, First of all thank you for this useful video. Does this solution work with the Oracle databases. Do you have any videos how can we set up Oracle database connection in Power Automate? Thank you again!
Hi,great stuff thanks but i noticed there is a lag of few mins when we create a new table and its not immediately read in flow?could you please expalin if its true.
Good video! Thanks for posting it. However, I was hoping that settings for the different SQL Server connector actions would be discussed. Specifically, I am having trouble with the timeout setting on the Execute stored procedure (V2) action. I have set it to 30 minutes but it continues to fail after 2 minutes with the message "GatewayTimeout". Is this a limitation or bug or do I need to change another setting in addition to this one?
You guys did good. I am super disappointed that flow gets so little support. Marketed for "no code" but documentation sucks and this is the only thing I could find that was even remotely helpful. You should explain the syntax required for Aggregation transformation, Filter Query, Order By, Skip Count, Top Count, Select Query. I can't find anything that explains how to write one of these. I had to plug and guess until it started to return things I needed. I can't figure out Aggregation transformation at all. Super disappointed. And sense the Execute SQL Query won't work with an on prem gateway I was stuck trying to use other connectors that want things written a specific way that doesn't make sense to me because writing SQL and VBA is the only thing I know. Sorry for the rant this just sucks.
Thanks for Sharing! having an issue where my database table requires Employee ID when inserting the Row which in shouldn't be happening unless we are updating the row. Any suggestions?
Hey Chahat, Are you still having the same problem here? I'm sorry if I have missed your email. Just a hint here, check how the primary key column values are being generated.
I used template for Sql Server to Power Bi data set . I have to manually refresh the report in services to se the changes. How can I do refresh the report automatically please help.
Hey Anand, your problem is not Flow related :) You need to create a streaming dataset in Power BI for the data to be refreshed in real time! Check the last 10 minutes of this video th-cam.com/video/-oiMyhR7QBU/w-d-xo.html
Hi Guys, any idea how this works with PowerBI streaming data set?, I have a flow which pushes the DB rows to PowerBI streaming data set. The problem is SQL connector on flow is pushing all the DB rows instead of pushing the only newly created ones. This is creating a duplicate data in PowerBI data set. I have searched a lot in internet but couldn't found anything. Please help me if you are aware of any solution.
Hi Bhargav, Mmmm, this doesn't sound right at all! How's your flow gets triggered? I'm assuming that you trigger the flow based on newly added rows (there is a template for that) and then add the row that gets picked up to the data set. Check your run history, and see how many times the your flow is being triggered. Also check this video for reference on how to add data to your streaming dataset in Power BI th-cam.com/video/-oiMyhR7QBU/w-d-xo.html
Great stuff, guys!!!
Thank you bro! ❤️
@@JonJLevesque
Is there a way to automate sql database -> Power Bi Desktop -> Power Bi Service in end-to-end fashion without having to open any app at all???
For example, use Python to do so?
I sincerely love the fact that Ahmad was consistent with his star wars jokes and references. Awesome presentation!!!
He’s so awesome about that! He always builds demos with real character to them.
Great video. Looking for some education on how to import excel into SQL Server using flow. Tried various things with no real guidance and not having any luck. Know of any videos or training I could cut my teeth on?
Thx
Great info on sql connector
Reza! Thanks bro :)
Thx for sharing! Really clear to follow and learn how to do this in a short amount of time.
Our pleasure! Thanks for taking a moment to comment!
Excellent movie, I'm big fan of SQL Server, Power Query and Microsoft Flow.
I hope the action of Open Transaction/Commit/Rollback to Microsoft Flow for automate business workflow 🐱🏍🐱🏍🐱🏍
Does the power automate per user plan include the SQL connector? I am currently using a plan 2 trial version, and need to move to a paid license, but not sure which license type has the SQL connector…
My issue is with the triggers. The trigger concerning when an item is created works fine. When I connect to the database I can find all the table names in the database through the dynamic content. If I try using the trigger when an item is modified I can connect to the database, but nothing is displayed in the table name field through dynamic content. If I try using a custom value (the table name I am trying to use) nothing happens when I modify something in the SQL table. Any hints on what might be the issue?
Very cool, I am a old ECM guy but new to Flow. I see a couple of applications, but, I could be all wet.
The first application is retrieving data from SQL and passing it to metadata in a SharePoint library to retrieve documents.
The second is the reverse of that and passing metadata that was captured in SharePoint, probably from a document, to a SQL database.
Cool. Thanks for sharing😍😍
No problem!! :)
Hi Guys,
First of all thank you for this useful video. Does this solution work with the Oracle databases. Do you have any videos how can we set up Oracle database connection in Power Automate? Thank you again!
I'm interested in this too
Hi,great stuff thanks but i noticed there is a lag of few mins when we create a new table and its not immediately read in flow?could you please expalin if its true.
hi! in PowerAutomate desktop, can I create a new xml variable and set it's content? atfterward write it to xml file? Thanks a lot!
Good video! Thanks for posting it. However, I was hoping that settings for the different SQL Server connector actions would be discussed. Specifically, I am having trouble with the timeout setting on the Execute stored procedure (V2) action. I have set it to 30 minutes but it continues to fail after 2 minutes with the message "GatewayTimeout". Is this a limitation or bug or do I need to change another setting in addition to this one?
You guys did good.
I am super disappointed that flow gets so little support. Marketed for "no code" but documentation sucks and this is the only thing I could find that was even remotely helpful. You should explain the syntax required for Aggregation transformation, Filter Query, Order By, Skip Count, Top Count, Select Query. I can't find anything that explains how to write one of these. I had to plug and guess until it started to return things I needed. I can't figure out Aggregation transformation at all. Super disappointed. And sense the Execute SQL Query won't work with an on prem gateway I was stuck trying to use other connectors that want things written a specific way that doesn't make sense to me because writing SQL and VBA is the only thing I know. Sorry for the rant this just sucks.
How often the data set is automatically refreshed is mean the latency of refresh
Help!. I'm trying to load an attachment from SQL to sharepoint list. When I opened the file on said list, the file got corrupted
Does it work with SQL SERVER on PREMISE ? I mean, does it works with SQL SERVER 2014 that I keeps in a specific server (NOT AZURE) ?
The power query is gold
Great tutor. Thanks so much Jon
Thanks for Sharing! having an issue where my database table requires Employee ID when inserting the Row which in shouldn't be happening unless we are updating the row. Any suggestions?
+chahat jaiswal send Ahmad an email to an@infoworker.no - he will know!
Hey Chahat,
Are you still having the same problem here? I'm sorry if I have missed your email.
Just a hint here, check how the primary key column values are being generated.
I used template for Sql Server to Power Bi data set . I have to manually refresh the report in services to se the changes. How can I do refresh the report automatically please help.
Hey Anand, your problem is not Flow related :)
You need to create a streaming dataset in Power BI for the data to be refreshed in real time!
Check the last 10 minutes of this video th-cam.com/video/-oiMyhR7QBU/w-d-xo.html
Can I create an excel file instead of an HTML table?
Hi Guys, any idea how this works with PowerBI streaming data set?, I have a flow which pushes the DB rows to PowerBI streaming data set. The problem is SQL connector on flow is pushing all the DB rows instead of pushing the only newly created ones.
This is creating a duplicate data in PowerBI data set. I have searched a lot in internet but couldn't found anything. Please help me if you are aware of any solution.
Hi Bhargav,
Mmmm, this doesn't sound right at all! How's your flow gets triggered?
I'm assuming that you trigger the flow based on newly added rows (there is a template for that) and then add the row that gets picked up to the data set.
Check your run history, and see how many times the your flow is being triggered.
Also check this video for reference on how to add data to your streaming dataset in Power BI
th-cam.com/video/-oiMyhR7QBU/w-d-xo.html
31:00- filtering
bro ...
Yo!
Create the connector from scratch ! Dislike for that !