Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
MauricioMaschke
New Member

API Connection

‎10-20-2023 11:24 AM

I am trying to use data from an Web API with this URL:

http://54.207.13.112/bi/bigdata.php?base=XXXXXXXXXXecleticamaster&tabela=vendas&data_ini=042021&data...

To create the dashboard on PBI Desktop I use the parameter TRUE. With this we take a month of data just to create de dashboards. To take all the data we need to change the parameter to FALSE and update only 1AM to 3AM.

Who can I change this? If a change before upload to PBI online its loose the data.

I tried to create a parameter in PBI Desktop, but I don't know how to use this in the URL.

Labels:
Message 1 of 2
507 Views
0
1 REPLY 1
lbendlin
Super User
Super User

‎10-22-2023 04:09 PM

You probably want to store the results of these API calls in raw format (JSON files, for example) and then consume/combine these files in Power Query.

Message 2 of 2
467 Views
0

Helpful resources

Announcements
Fabric Data Days is here Carousel

Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

View All