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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors