Power BI Service Showing error Paginated api Query | Power Query

[bmsuhaib]

Hi All,👋

I am getting the above error while i add the below Query to my power bi Desktop to pull the API Data using basic authentication Username & Password as shown below(Default Anonymous Credentials) 

The Data is Paginated. The issue here is that I don't have any Page Number / Total Pages/ Total Record count for my data to try some other methods.

While importing the data I get 2 fields

1. List(current page items) 
2. Next page url/value

The outputs recieved for now is as below in power bi desktop for 10k data as of now which keeps increasing. As of now each Page containg 1000 records which may vary.

1)

2) generate function - hand authorized query as shown in code above

Generate function is causing all the issues here. -(showing hand authorized query) 

After step 2 all are done easily... 

The above code works fine in Power BI Desktop. But it gives above erro in Power BI Service. I am not even getting data source credentials / refresh scheduling option in power bi Service. 

If someone give me alternative step/code for generate function too it will help me. 

Can someone please help me with the solution!!!! 

[lbendlin]

Dynamic data sources like yours are not supported on the service. You need to refactor your query to make it look like a static query.