API

[Anonymous]

Hello everyone,
I am trying to put in place a connexion to a REST API using Power Query. The goal is to set it as a perene data source and use it to create a dataset that will underly different reports. I was wondering if there is somewhere an efficient step-by-step procedure to follow in such case.

Thanks for any relevamt information regarding this question.

Regards.

Dany

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Does pbit meet your requirement?

- A template file contains only the query definitions, data model and reports, but not the data. So it's very small.

- When opening a pbit file the user can enter parameter values. Then only the data matching these query parameters is loaded. 

For more details, please check the online document.

https://docs.microsoft.com/en-us/power-bi/desktop-templates