
Announcements
Hi,
I wanted to build a flow that would download our company SQL View definitions every week as a backup (our PBI models are built on these views). I created a SQL view that retrieve these information as you can see below :
But when I create flow in Power Automate - Get Rows function or Transform through Power Query somehow skips the 'definition' column. It's either null in Transform Data using Power QUery :
Or it just doesn't see the column when using Get Rows (can't actually see it on the picture of the flow) but in my raw outputs i only have json format for name column :
"
{"@odata.etag":"","ItemInternalId":"24e0f193-a4e1-4f93-876e-116e987d3a02","name":"powerautomate_ad_updater_new_employees"},{"@odata.etag":"","ItemInternalId":"99cdd709-097b-42c4-b0b4-f08b4d3434d5","name":"jira_solutions_v"}
Any idea why is it happening and how to go around it?