Forum Discussion
Get data from api loads in powerquery with correct data but as soon as i close & apply, i get error
Hello everyone, for reference this is my code let
// Set Dates
Today = DateTime.LocalNow(),
LastYearDate = Date.AddYears(Today, -1),
TodayFormat = DateTime.ToText(Today,"yyyy...
thats from their api documenttion they do and the data loads perfectly in powerquery so yes it exists the issue isnt from page its from the Relativepath of report_id being dynamic
lbendlin for more clarification
if i hardcode reportid into the reativepath, the data loads, it only gives error when reportid is dynamic