I would like to share my recent experience with loading a CSV file via Dataflow to Dataverse with you. Today, I downloaded the list of leads from the conference we sponsored last week. There is no better way to load it to my sales app on Dataverse - it's a Dataflow way! At least for… Continue reading Dataflows for PowerApps: loading data from CSV file without copying it to OneDrive in advance. 💖😎👍
Dataflows for Power Apps: run import from the app
As you know I am a very big fan of Dataflows. The biggest ask from me was always the ability to trigger the Dataflow refresh on demand from a Power App. Initially, Dataflows you could only run from the maker portal. You need all sort of "powerful" security roles and permissions to do so. Dataflows… Continue reading Dataflows for Power Apps: run import from the app
Getting data from a function in an on-prem SQL server via Gateway in Power Automate
Dataflow magic in Power Automate. SQL with Power Query in Power Automate. Did you know you can do this?
“We are screwed!”
me at the moment of technology induced panic
That was the feeling when I saw the below error messages.
The client’s setup is an on-prem SQL server exposed to the cloud via an on-prem Gateway. It works perfectly fine for exiting Dataflow integration, but this time we needed data from a function in Power Automate.
Now problem, you can use SQL server connector, right?
Almost (but yes, if you read this post or knew before).
Set back #1
You cannot use “Execute a SQL query (V2)” with an on-prem gateway connection. Not supported!
Sure, let’s then use “Execute stored procedure (V2)”.
Set back #2
Apparently, you cannot return dataset from the function. Can call it if it was just a function or procedure without return value. But if it returns data – bad luck!
Panic mode on!
Wait, but what if…
Power Query to the rescue! Again.
View original post 159 more words
Dataflows for Power Apps: calling a table-valued SQL function with Power Query
It's very easy to query SQL table-valued function to retrieve the result with Dataflows. This is how we do this. Let's connect to a database. It will work via gateway as well. Select your function. Pass the parameter if required. Now you can use this table to merge with other tables or map and load… Continue reading Dataflows for Power Apps: calling a table-valued SQL function with Power Query
❤ Dataflows for Power Apps ❤: “The column ‘[Column_name]’ of the table wasn’t found.” error while loading multiple tables
There is an option to load data to multiple table in one go in Dataflows. These tables can be related. Dataflow engine calculates the dependencies and determines the correct order for loading. It's a very cool functionality, however, you have to be aware of some potential issues as well as available workarounds. Problem: I am… Continue reading ❤ Dataflows for Power Apps ❤: “The column ‘[Column_name]’ of the table wasn’t found.” error while loading multiple tables