![]() ![]() GetList = Json.Document(Web.Contents(" " & T & you tell me why this query can't refresh in power bi service - only desktop? I get error message saying this data source can't be refreshed in Power BI online.Ĭheers GGetty. Source = Json.Document(Web.Contents(" ")), Please let me some sample code from the Advanced Query editor in Power BI desktop that would work for making an API call to Blackbaud's ON products, get and store the token from Blackbaud API as variable (NOTE: these are fakes URLs, usernames, passwords, and SLI id for list, but I promise it works in Power BI desktop just be sure your user has access to the Web Services API Manager role and that the list you're pulling from also gives access to the Web Services API Manager role and/or your username). ![]() did you get this to work for you? – did this solution work? Please can you help me find out how to get connected. I then also closed the window and tried to look for the “to table” option in your solution, and I could not find this either or it was greyed out. Each time I did it, the loading preview window opened, and did not load, even after waiting 15 minutes. I tried, anonymous, Basic and Web API options, none of them worked. Then it gave me several options to choose from: Anonymous, Windows Credentials, Basic, Web API and Organisational Account. I entered the URL above into the Web connector box in PowerBi. ![]() Your API key for the Sandbox environment is: (they gave me a key). We use basic auth for authentication API calls and you would use the same login that you created in the step above. When you are ready to begin, use the following URL for the API. Note that I am not very experienced in doing this and this is my first time. I tried what you suggested above, but it does not work for me. ,Header='Authorization: Basic c29tZXVzZXI6c29tZXBhc3dvcmQ= || US-Customer-Api-Key: ABCDE' You can write queries like below (JSON Driver Example) Step-1 : Create your ODBC DSN to call REST API or read JSON / XML data Step-2 : Build / Test your REST API Query Step-3: Import REST API data in Power BI using ODBC connection (Under Get Data > More > Other) If its simple JSON / XML then fine but in the real world, many other issues arise such as pagination, flatten the hierarchy, error handling, security (OAuth, Basic, Certificate). Zendesk, Twitter, Google API, Amazon AWS)īasically, Calling REST API in Power BI can be a challenging process because you have to deal with many complex issues. ZappySys has introduced powerful API Drivers to query virtually any JSON / XML API services in Power BI (e.g. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |