Forum Discussion
Power BI Service " This dataset includes a dynamic data source"
Here is M code that works fine in Power BI Desktop and refresh works fine. let
StartYear = 2021,
EndYear = 2022,
Years = Table.FromList({StartYear..EndYear}, Splitter.SplitByNothi...
amitchandak
Super User
Super Usergingercat123 , I you arrre using a m parameter , then you should be able to set that up in dataset setting -> parameters
Also check this way
Thanks amitchandak please could help with below line , not sure what i am doing wrong.
= Table.AddColumn(#"Added Custom1", "URL", each "https://www.abc.com",[Relativepath="rest/agency/campaigns/engagement?api_id=abc&api_key=abc&api_identifier=abc&date_from="&[sdate]&"%2012:01:01&date_to="&[edate]&"%2012:01:01&type=CLICKS&include_contacts_data=N&include_extended_data=N&include_split_info=N"], type text)i get below error: