cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kimm Frequent Visitor
Frequent Visitor

The resource name isn't valid

Hi,

 

I have recently used a Time Date Filter function by creating a Period table using the following function:

 

(
PeriodName as text,
StartDate as date,
EndDate as date,
SortOrder as number
) as table =>
let
DayCount = Duration.Days(EndDate-StartDate)+1,
DateList = List.Dates(StartDate,DayCount,#duration(1,0,0,0)),
AddPeriodName = List.Transform(DateList,
each {PeriodName,_,SortOrder}),
CreateTable = #table(
type table[Period=text, Date=date, Sort=number],
AddPeriodName)
in
CreateTable

 

This created a Period table which in effect splices my data according to 

Current YTD, MTD, WTD and Rolling Week Month and Year.

 

All the data refreshes correctly via desktop mode however I always get an error when it refreshes using the network gateway and it keeps giving me this error:

 

Data source type: 
Data source error:The resource name isn't valid : Period.

 

I don't know what to do to enable it to accept the resource name and refresh the data online.

 

Any help would be much appreciated please?

4 REPLIES 4
Super User
Super User

Re: The resource name isn't valid

Is the function name "Period"?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


kimm Frequent Visitor
Frequent Visitor

Re: The resource name isn't valid

Oh - should I name the table the same name as FX name I used?

 

I indicated CreatePeriodTable under my FX name - but its basically a create table function.

 

I had renamed the table to Period though - will it help if I change the table name to mimic the FX name (CreatePeriodTable)?

kimm Frequent Visitor
Frequent Visitor

Re: The resource name isn't valid

Oh never mind - it didnt allow me to rename the table to the same name as the function as it said a query already existed with that name.

 

Cant seem to understand then why it cant accept Period as the resource name for the table....

kimm Frequent Visitor
Frequent Visitor

Re: The resource name isn't valid

I still cant get this to work unfortunately - any ideas how to overcome the invalid resource error code? What normally needs to be changed (ie why does this error come up?)

 

Really appreciate any help on this!