Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
stevehuff
Frequent Visitor

Live Data Connections to PowerBI Cloud Service

Hello! I'm hitting a wall when trying to make reports available on the PowerBI cloud service that can have live data refreshed. I have built out several reports on the Desktop version of PowerBI that connect to our CRM software (Aptly) and refresh the data. The API is paginated and only allows for one page to be called at a time, so I use the following methods to get the data we need

 

1) Function to allow for page number to be called

(Page) =>
let
Source = Json.Document(Web.Contents("board id?x-token=apitoken&page=" & Number.ToText(Page)))
in
Source

2) Query to run the above function up to a certain page count

let
Source = List.Generate(
() => [page = 0, data =functionname( 0 )],
each [page]<150,
each [page = [page] + 1, data = functionname( [page])]),

in

Source

 

I did try using a gateway to refresh the data, but the error I ran into was that it couldn't refresh a live data feed. It feels like it should be possible to have the live data feed linked, but I haven't quite found a path to make this happen. Am I missing something obvious here, and/or is there another way to build out the data request? Any and all help is appreciated!

 

Link to API documentation for reference (in case this helps): https://www.getaptly.com/api/
The specific request path we use is the Get Cards path. 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

"live"  and "live"  are two different things. It may be live data on the CRM side, but any API call in Power Query is automatically in Import Mode - the opposite of "live".

 

To refresh that data source via a gateway you should follow the documentation for Web.Contents to mask the dynamic part of the request.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

"live"  and "live"  are two different things. It may be live data on the CRM side, but any API call in Power Query is automatically in Import Mode - the opposite of "live".

 

To refresh that data source via a gateway you should follow the documentation for Web.Contents to mask the dynamic part of the request.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors