Trying to pass Kusto query as a paramter in Power bi

Microsoft

 Hi Team,

 

Actually I have 4-5 kusto queries which are stored in Azure SQL Database as it will be frequently change so client will be updating the query and will keep that query into azure SQL database.

 

My job is to get that query dynamically from SQL and pass as a paramter in power BI. So that everytime if client make the changes in the kusto query it will dynamically change the parametrized query and updated data will be shown.

 

but It throwing an error as DataSource.Error: Web.Contents failed to get contents from.....

query characters are more than 2000 and i know it is a limitation of power BI with kusto so Can you please help me with any other solution which can be work around

0 Replies