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

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

pbinewdev — Thu, 02 Mar 2023 18:49:39 GMT

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!

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

Adamboer — Fri, 03 Mar 2023 11:49:13 GMT

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.

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

pbinewdev — Sat, 04 Mar 2023 00:51:53 GMT

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 🙂