Passing parameters from c# code to M query parameter failed

pcho — Wed, 03 Jul 2024 20:36:39 GMT

Hi, I am trying to understand why the ‘UpdateMashupParametersRequest’ (img1) code is working in the AppOwnsDataStarterKit sample app, but not in my app(img2)!! I am seeing a dataset error in (img3). Wondering is it because I am using authentication type as ‘Service Principal’??

App-Owns-Data-Starter-Kit->PowerBiServiceApi.cs->OnboardNewTenant

App-Owns-Data-Starter-Kit/Docs at main · PowerBiDevCamp/App-Owns-Data-Starter-Kit · GitHub

img1

img2

img3

Thanks,

-Peter

Re: Passing parameters from c# code to M query parameter failed

Anonymous — Thu, 04 Jul 2024 02:12:24 GMT

Hi @pcho,

For the error message, it seems like your connection string include dynamic part which can't be schedular refresh.

Have you tried to modify your M query with optional parameter to handle these scenario, and use the new version report in the sample?

Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code
Regards,

Xiaoxin Sheng

topic Re: Passing parameters from c# code to M query parameter failed in Developer

Passing parameters from c# code to M query parameter failed

Re: Passing parameters from c# code to M query parameter failed