Forum Discussion

sbenzaquen's avatar
sbenzaquen
Helper I
5 years ago

Connecting Harvest API with PowerBI

Hi,   I'm trying to connect Harvest and a PowerBI dashboard through an API. I managed to connect the data through a web connection and pass the credentials stage,  however, only 100 rows/1 page of ...
Need Help
JOC_DRA's avatar
JOC_DRA
New Member
4 years ago

Thank you both for this you saved me.  I want to share my code too if it is hopeful for anything--- which is nearly the same as the previous poster:

 

BaseURL = "https://api.harvestapp.com/v2/projects?access_token=#######.pt.XXXXXXXXXXXXXXXXXX&account_id=######",
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = List.Numbers(0,10,100),
#"Converted to Table" = Table.FromList(#"Changed Type", Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Changed Type1" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type text}}),
#"Added Custom" = Table.AddColumn(#"Changed Type1", "Custom", each Json.Document(Web.Contents((BaseURL&"limit=100"&[Column1]))))