Forum Discussion

sonam7's avatar
sonam7
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

PowerBI gateway error while setting up datasources

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/serv...
Need Help
v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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-t-work/td-p/2450

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9312540-make-functions-refreshable-when-the-data-source-is

 

Regards,

Daniel He

sonam7's avatar
sonam7
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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.