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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Invalid characters for names of workspaces, dashboards, etc.

 

Power BI seems to be very flexible in what characters are allowed in the names of dashboards, reports, etc. Are there any invalid characters at all for these names?

 

Due to the associated creation of a group, do workspace names have any practical character restrictions that other Power BI object names do not?

 

Are there any characters that are valid within Power BI, but which don't work well when creating objects via the API?

 

Thanks,

Tim Curwick

3 REPLIES 3
Greg_Deckler
Super User
Super User

Hmm, that's a very broad question and I am not aware of any documentation that covers the entire breadth of which you are asking. I did however recently do an Introduction to DAX presentation and here is a note from that:

 

The following characters and character types are not valid in the names of tables, columns, or measures:

  • Leading or trailing spaces; unless the spaces are enclosed by name delimiters, brackets, or single apostrophes.
  • Control characters
  • The following characters that are not valid in the names of Power Pivot objects:
  • .,;':/\*|?&%$!+=()[]{}<>

 

Not entirely what you are asking for but the best I have at the moment.


@ 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...
Anonymous
Not applicable

Greg,

 

I'm not concerned with data objects at this time. I'm at a meta level, creating API wrappers and automations for working with Power BI objects, not the stuff within them. Specifically, this afternoon, I'm creating wrappers for API calls to create dashboards and workspaces. I want to know if I need to check names for invalid characters before creating them.  The wrappers will be used globally, so I need to allow everything I can, but I want to anticipate and catch characters that would break something.

 

Manually I can successfull create dashboards with every character on my en-us keyboard, including all of the characters you listed. This leads me to hope that the Power BI team has successfully isolated these display names from anything which may try to parse them in anyway, thereby allowing any valid string to be a valid dashboard name.

 

I am looking for confirmation of this hope so that I can skip character validation, or specific refutation of it so that I can perform appropriate character validation.

 

Whatever the state of the names of dashboards and similar objects, I suspect workspace names are more restrictive, due to restrictions in the names of the associated Group that is created. So I am looking for confirmation or additional details on this assumption as well.

 

Thanks,

Tim Curwick

 

 

I've never seen anything like that documented here:

 

https://docs.microsoft.com/en-us/rest/api/power-bi/

 

Which is where I would expect that to be.


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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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