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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
jymjams75
New Member

API Request

Hi everybody,

I need your help !

 

I would use PowerBI to get data from sevrals apps : website metrics, twitter etc.

It was simple because i just had to change parameters in the URL. Example : myservice.fr/request/data/getData?param=%7B%22columns%22:";"%5B%22click%22,%22event_name%22,%22p1.m_visits%22,%22 etc.
I could get date that way, it was easy.

 

Now, I have a new service and it seems to me that it's kinda different.

I have the URL : https://myservice.com/report/batch/query.json
And i have a body : 

 

 

 

{
"reports": [
{
"kind": "rt#pagetree",
"path": "mcWEBSITE[1234].mcGLOBALPAGETREE.mcPAGETREE",
"dateRanges": [

{ "dateFrom" : "2024/01/01", "dateTo": "2024/03/07", "dateFormat" : "YYYY/DD/MM" }
],
 etc.

 

 

I don't understand how I can use that in PowerBi...where do I have to put the body ?

 

Best regards

1 REPLY 1
lbendlin
Super User
Super User

There's a Content attribute for that.

Web.Contents - PowerQuery M | Microsoft Learn

Example 2

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors