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