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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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"?


Follow on LinkedIn
@ 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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Top Solution Authors
Top Kudoed Authors