Forum Discussion
Passing parameters from c# code to M query parameter failed
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
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
1 Reply
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