Forum Discussion

vsslasd1's avatar
vsslasd1
Icon for Helper III rankHelper III
3 years ago

PowerBI Report Filter using a URL with a table or column name where there are spaces

Hello, 

The basic syntax of the Filter is: 
https://app.powerbi.com/groups/<GUID>/reports/<GUID>/ReportSection?filter=JCMasterJob/Job eq 'xy-12-3456'

The above works great. 

 

But when the table name has spaces in it, e.g. "JC Master Job" instead of "JCMasterJob", it fails.

 

What sort of punctuation resolves the spaces in the table name or the Column name error ? 
Thank you

2 Replies

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion

    vsslasd1 

     

    Try replacing space with %20 and check again

     

    e.g. Hello World

    will be  Hello%20World

    • vsslasd1's avatar
      vsslasd1
      Icon for Helper III rankHelper III

      Thank you, I tried that and unforunately  it didn't work.