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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
pbinewdev
New Member

Is it possible to programmatically set the data panel name for a web data source that is a CSV?

If I add a web data source and set it as an api I am developing for my app e.g.  https://www.myapp.com/api?key=12345&data=AppStats (which returns a CSV), then once it's connected it shows as ?key=12345... in the data panel.

 

Is it possible for the api to set the name that will appear in the data panel, so that once connected it shows e.g. App Stats instead?

 

My guess is that there might be a header that can be set to communicate the name to PowerBI, but I haven't been able to find anything so far.

 

Thanks!

1 ACCEPTED SOLUTION

Unfortunately the example didn't work, but the concept is sound! Changing the URL to https://www.myapp.com/api/AppStats.csv?key=12345&data=AppStats did work.

 

Thanks 🙂

View solution in original post

2 REPLIES 2
Adamboer
Responsive Resident
Responsive Resident

It is possible to set the data panel name for a web data source that is a CSV by specifying the name of the file in the URL. For example, if the URL is https://www.myapp.com/api?key=12345&data=AppStats.csv, the data panel name will be "AppStats". Alternatively, you can also rename the data source in Power BI after it has been imported. There is no header that can be set to communicate the name to Power BI.

Unfortunately the example didn't work, but the concept is sound! Changing the URL to https://www.myapp.com/api/AppStats.csv?key=12345&data=AppStats did work.

 

Thanks 🙂

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.