PowerBI gateway error while setting up datasources

[sonam7]

Hi,

I have setup a new enterprise gateway. I am trying to merge cloud and onpremises datasources used in my datasets.

I am using this link to do so https://docs.microsoft.com/en-us/power-bi/service-gateway-mashup-on-premises-cloud.

However, when I am trying to add the cloud datasources to my gateway. I am getting the following error. Can someone please help me with understanding this error and how do I solve this. Thanks!

 

[v-danhe-msft]

Hi @sonam7 ,

Could you have checked if you have entered any parameters for your data? You may refer to below links that if you have set a paramter for your data like this:

let
    Abfrage = (path as text) =>

 https://community.powerbi.com/t5/Integrations-with-Files-and/Refreshing-queries-with-functions-doens...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9312540-make-functions-refreshabl...

Regards,

Daniel He

[sonam7]

Hi @v-danhe-msft 

No I have not used any function in my query. I have a hardcoded folder path query. Please see it below:

let KustoQuery =
let
Source = Json.Document(Web.Contents("https://Usage360.kusto.windows.net/v1/rest/query",

This is what the beginning of my query looks like where I am trying to connect to kusto to fetch results for my table.