Tap to unmute

Power BI - Tales From The Front - REST APIs

  Рет қаралды 16,620

Hoosier BI

Hoosier BI

Күн бұрын

Пікірлер: 11
@totemimaging
@totemimaging 3 жыл бұрын
Fantastic - clearly explained steps to an issue with REST APIs that I've been fiddling around with for quite a while! Cheers!
@carlos_hernandez
@carlos_hernandez 2 жыл бұрын
Thanks for putting this together. I was able to recreate the steps in less than 5 minutes for a problem I had been stuck on for a couple hours.
@archangel0071
@archangel0071 9 ай бұрын
Thanks for this! Question though, do you know if this type of set up in the queries is still compatible with the scheduled online refresh?
@chrispy7299
@chrispy7299 2 жыл бұрын
I have tried this and get an error "Invalid URI: The hostname could not be parsed" when I use the field value for the offset, any ideas?
@hoangvucamranh
@hoangvucamranh 3 жыл бұрын
I do like OffsetSample and then I get the error "Formula.Firewall: Query 'Query1' (step 'Added Custom') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination." Is there any way I can ask for your help?
@jonathanhayton314
@jonathanhayton314 Жыл бұрын
I get this too did you resolve it ?
@jonathanhayton314
@jonathanhayton314 Жыл бұрын
Sorted it if you go to File > Options>Privacy, and select Ignore the Privacy Levels and potentially improve performance
@salvador9403
@salvador9403 3 жыл бұрын
Hi Hossier, thanks for the content. You are solving my current issue: sourcing data through different pages using a REST API! However, I think you have not really explained how you set up the OffsetExample table. Could you please elaborate more on how you inset the List.Number formula? I'm struggling with that step....
@totemimaging
@totemimaging 3 жыл бұрын
You need to create a 'New Source > Blank Query' then enter the code adapted, if necessary, to the references (for example 'totalcount') that you've used in your report).
@scooterza
@scooterza 3 жыл бұрын
Hello Hossier, your video has been very helpful. However, I am getting stuck at the step shown at 16.50. When I do this step, I keep getting an error saying "We couldn't authenticate with the details provided. Please try again." Any suggestions? I created a string as follows: = Table.AddColumn(#"Changed Type", "Custom", each Json.Document(Web.Contents(BaseURLandKey & "&offset=" & [Column1] & """,[Headers=[#""X-Integration-ID""=""MY_INT_ID"", #""X-API-Token""=""API_TOKEN_NO""]]")))
@basyasalid4988
@basyasalid4988 Жыл бұрын
Is there a source file for these steps?
How to Use List Generate to Make API calls in Power Query
18:27
BI Gorilla
Рет қаралды 44 М.
СИНИЙ ИНЕЙ УЖЕ ВЫШЕЛ!❄️
01:01
DO$HIK
Рет қаралды 3,3 МЛН
小丑女COCO的审判。#天使 #小丑 #超人不会飞
00:53
超人不会飞
Рет қаралды 16 МЛН
IIoT Lecture Module 4: Controllers
47:04
Hartmann Automation
Рет қаралды 4
How to easily automate boring Excel tasks with Power Query!
17:10
MyOnlineTrainingHub
Рет қаралды 1,6 МЛН
Power BI REST API no-code options
9:30
Guy in a Cube
Рет қаралды 175 М.
Row Context in DAX
20:42
SQLBI
Рет қаралды 106 М.
How YOU Can Make API Calls in Power Apps WITHOUT Pre-Built Connectors
16:27
SLICERS done Differently | Power BI
17:07
How to Power BI
Рет қаралды 183 М.
Power Query - Looping and API Calls!
9:55
BA Sensei
Рет қаралды 10 М.
Get SharePoint List Data with Power BI ... Fast
21:04
Hoosier BI
Рет қаралды 36 М.