Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
kimm
Regular 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
kimm
Regular Visitor

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!

Greg_Deckler
Super User
Super User

Is the function name "Period"?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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
Regular Visitor

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....

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors