Forum Discussion

kimm's avatar
kimm
Regular Visitor
9 years ago

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

    • kimm's avatar
      kimm
      Regular Visitor
      9 years ago

      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's avatar
        kimm
        Regular Visitor
        9 years ago

        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's avatar
    kimm
    Regular Visitor
    9 years ago

    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!