Skip to main content

Power BI

Needs Votes

Power Query functions in URL using a web data source under on-premise data gateway

Vote (239) Share
's profile image

on 07 Oct 2016 14:08:33

Add the ability to use Power Query functions in the source string not only for the PowerBI Desktop, but also to on-premise data gate
Now It's not supported to type Power Query functions as web URL when we create a web data source under on-premise data gateway

Comments (8)
's profile image Profile Picture

fefe23fb edde-4609-b081-c16b01e63bc9 on 05 Jul 2020 22:32:37

RE: Power Query functions in URL using a web data source under on-premise data gateway

Please add this feature

's profile image Profile Picture

ba5230fa f9a6-4312-a7c9-f7b4109bc54d on 05 Jul 2020 22:32:28

RE: Power Query functions in URL using a web data source under on-premise data gateway

also got the same problem
developers, please correct this error. because it really interferes in BI building

's profile image Profile Picture

fa57ffa8 79fd-492b-99bd-3995c7ef5306 on 05 Jul 2020 22:32:22

RE: Power Query functions in URL using a web data source under on-premise data gateway

Developers do not meet on this idea..

's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:32:17

RE: Power Query functions in URL using a web data source under on-premise data gateway

It is necessary to simplify data flows

's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:32:10

RE: Power Query functions in URL using a web data source under on-premise data gateway

I think this can help automate many operation and simplify the chain of data flow
Please, implement this idea

's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:32:10

RE: Power Query functions in URL using a web data source under on-premise data gateway

Support the idea
Much needed feature

's profile image Profile Picture

a3309361 99be-ea11-a812-000d3a8ddfb2 on 05 Jul 2020 22:32:04

RE: Power Query functions in URL using a web data source under on-premise data gateway

Perfect! Now we use PowerShell & Windows_Task_Sheduler & JSON_file to get data on current date to PowerBI_Destop for on-premise data gateway updating.
This is very complicated and strangely on-premise data gateway cannt update data with function in source string..
Developers, PLEASE, perform this idea

's profile image Profile Picture

94d03787 64b0-49f2-b488-9b8d2cfe6523 on 05 Jul 2020 22:31:57

RE: Power Query functions in URL using a web data source under on-premise data gateway

Good idea!
Addin function to source string with updating using on-premise gateway will let to use powerbi for more sources