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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Jackbaz99
Helper I
Helper I

API Online Refresh - Cannot Connect

Hi all,

 

Ive managed to create a report that runs from an API online, it is a ticketing system called fresh desk - Power BI is just making the data more manageable and visually clear. 

 

Anyway - the problem I have is that I can refresh within the desktop but when I upload to the PBI Service I cant refresh. Ive read up a lot on this and things to do with dynamic data sources ect. However I have also seen someone manage to do this by making the url a text string first and then manually create the table. 

Can someone look at my code and decide whether it is possible for me? I don't have much knowledge of this area.

Thank you,

 

Jack

 

 

 

(Page as number)=>
let
    Source = Json.Document(Web.Contents("https://middlesexgroup.freshdesk.com/api/v2/tickets?updated_since=2010-01-01T02:00:00Z&include=requester&include=description&page="&Number.ToText(Page))),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"cc_emails", "fwd_emails", "reply_cc_emails", "ticket_cc_emails", "fr_escalated", "spam", "email_config_id", "group_id", "priority", "requester_id", "responder_id", "source", "company_id", "status", "subject", "association_type", "support_email", "to_emails", "product_id", "id", "type", "due_by", "fr_due_by", "is_escalated", "custom_fields", "created_at", "updated_at", "associated_tickets_count", "tags", "description", "description_text"}, {"cc_emails", "fwd_emails", "reply_cc_emails", "ticket_cc_emails", "fr_escalated", "spam", "email_config_id", "group_id", "priority", "requester_id", "responder_id", "source", "company_id", "status", "subject", "association_type", "support_email", "to_emails", "product_id", "id", "type", "due_by", "fr_due_by", "is_escalated", "custom_fields", "created_at", "updated_at", "associated_tickets_count", "tags", "description", "description_text"}),
    #"Expanded custom_fields" = Table.ExpandRecordColumn(#"Expanded Column1", "custom_fields", {"issue_type", "machinearea", "group"}, {"custom_fields.issue_type", "custom_fields.machinearea", "custom_fields.group"}),
    #"Split Column" = Table.SplitColumn(#"Expanded custom_fields", "tags", each _, {"tags.0"})
in
    #"Split Column"

 

 

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @Jackbaz99,

You can take a look at the following blog and try to add relativepath and query options to your connector if they help for your scenario:

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An...

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

Hi @Jackbaz99,

You can take a look at the following blog and try to add relativepath and query options to your connector if they help for your scenario:

Chris Webb's BI Blog: Using The RelativePath And Query Options With Web.Contents() In Power Query An...

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
amitchandak
Super User
Super User

@Jackbaz99 , what is the issue it is giving it on power bi service?  Have updated datasource details under the data source setting and they are not working?

Hi @amitchandak the error when on the PBI service is 

 

You can't schedule refresh for this dataset because the following data sources currently don't support refresh:

  • Data source for Query1

 

Discover Data SourcesThank you 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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