Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

API calls with Pagination

I almost see the light at the end of the tunnel.   I am able to make a connection through an API call to my data source (Okta in this case) and was very excite until I looked at the data and notice...
Need Help
Show and Tell
Tips and Tricks
gabrielsroka's avatar
gabrielsroka
Frequent Visitor
7 years ago

Hi Anonymous

 

I spent some more time and I got a basic Custom Data Connector to work. It needs more work, but this should get you started.

 

This works with Power BI Desktop (as of now). Excel support may be added by Microsoft in the future.

 

1. In your Documents folder, create a folder called "Power BI Desktop\Custom Connectors" (mine already existed).

2. Download the code from https://github.com/gabrielsroka/gabrielsroka.github.io/blob/master/Okta.pq to Okta.pq and save it in the "Custom Connectors" folder.

3. In Power BI Desktop, go to File | Options and settings | Options.

4. Go the Security tab.

5. Under Data Extensions, select Allow any extension to load without validation or warning.

6. Restart Power BI Desktop

 

See https://github.com/Microsoft/DataConnectors for more info.

 

One thing I found by researching and experimenting (that I didn't see in the documentation) is you can use the Okta.pq file, you don't have to create a .mez file (which is a Zip file). You can even edit the Okta.pq file while it's loaded in Power BI Desktop -- this makes development much easier.

 

michaelsh's avatar
michaelsh
Kudo Kingpin
5 years ago

Thank you, gabrielsroka for sharing.

I am starting to work on a project that gets data from OKTA API.

I stumbled upon pagination and found your Custom Connector solution.

I am new to Custom Connectors, so before I begin, just wanted to make sure it is working for you.

Are there any updates since you published it? Is it ready to use for scheduling in the service?

Thank you