Forum Discussion
API NEWBEE
Hi Anonymous,
#1, Nope, you only need to learn the M query to know how to use a web connector to send and receive requests from specific result api with headers and optional parameters.
Below is the link about use web connector to get data from rest API with authorizations: (twitter API)
Pull data from a REST API Authentication
#2, Yes, power bi desktop backend query tables are using m query functions to get data. If you familiar with M query language, it should help for your scenario.
#3, The service you mention seems like integrate your data source API with their API interface that you still need to learn how to get data from rest API.
If you want to find a simple way, you should search for the supplier that provides the service to packaging rest APIs with a common interface(odata, odbc...) then you can directly use power bi connectors to get the result table records.
Regards,Xiaoxin Sheng
Hi Anonymous,
#1, Nope, you only need to learn the M query to know how to use a web connector to send and receive requests from specific result api with headers and optional parameters.
Below is the link about use web connector to get data from rest API with authorizations: (twitter API)
Pull data from a REST API Authentication
#2, Yes, power bi desktop backend query tables are using m query functions to get data. If you familiar with M query language, it should help for your scenario.
#3, The service you mention seems like integrate your data source API with their API interface that you still need to learn how to get data from rest API.
If you want to find a simple way, you should search for the supplier that provides the service to packaging rest APIs with a common interface(odata, odbc...) then you can directly use power bi connectors to get the result table records.
Regards,
Xiaoxin Sheng