Skip to main content
Microsoft Idea

Power BI

Needs Votes

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

Vote (246) 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

Ela 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

Mars El 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

Frizm 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

Power BI Ideas Admin 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

Power BI Ideas Admin 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

Power BI Ideas Admin 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

Power BI Ideas Admin 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

Harry 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