Hi Ruth, I always enjoy your videos! I'm wrestling with getting data from the Harvest time tracker. This is an account where we have a login, so it's not a straightforward process (although they do have a rest API). I'm clueless about API's and wondered if you had any videos where you deal with security, tokens, etc? Thanks!
Hello, Would you please make a video on, how to get Data from RESTful API which has "two Factor Authentication" e.g. Maconomy RESTful API framework. Thank you.
Hi, i am able to establish connection with API and able to refresh in power bi service also without any issue. BUT, when i publish my report to premium workspace and tried to refresh its throwing me this error => DataSource.Error: The underlying connection was closed: An unexpected error occurred on a send.. "API URL" . . The exception was raised by the IDbCommand interface. Table: "Table Name"
Hi, Ruth, great content as always! Do you know a way to get a user input (by a slicer) and then call the API based on that value? Exe: User select a radius length in a slicer than you call the API to get the area on the fly
@gulherme Pereira Have you somehow made such app in Power BI? If yes, can you give me some advice, how to made it? I try to made it using python, but it only work for definied visuals :(
This video has bridged a huge logic gap for me, thank you so much!
😃
hello, how do you add "Convert" to the menues to see the json content, at 6:13-6:14? Thank you!
Love from India 🇮🇳 , you helped me to upgrade my job
lol Chuck Norris taught Ruth Power BI. 👍👍
Knowledge comes always from the most unexpected sources 😂😂
Have one problem when commit on powerbi service.
The system not connect from variable connection source.
Hi Ruth, I always enjoy your videos! I'm wrestling with getting data from the Harvest time tracker. This is an account where we have a login, so it's not a straightforward process (although they do have a rest API). I'm clueless about API's and wondered if you had any videos where you deal with security, tokens, etc? Thanks!
Hello,
Would you please make a video on, how to get Data from RESTful API which has "two Factor Authentication" e.g. Maconomy RESTful API framework.
Thank you.
Can we change datasource from azure storage to API?
Please do a video on how to connect to jira
Hi, i am able to establish connection with API and able to refresh in power bi service also without any issue. BUT, when i publish my report to premium workspace and tried to refresh its throwing me this error => DataSource.Error: The underlying connection was closed: An unexpected error occurred on a send.. "API URL" . . The exception was raised by the IDbCommand interface. Table: "Table Name"
Never seen that error before, I am afraid 😳
@@CurbalEN Thanks for the response. Facing this weird issue for past 1 week. Will update if got something.
Yes please, you can report in also in issues.powerbi.com if it is something that happened suddenly
I am using different API but that API returns 50 rows per ID... How to do pagination on that? List. Generate returns empty list
Hi Ruth, does PBI support materialized views?
exactly what i was looking for...thank you so much
Perfect!
Awesome Ruth as always!
Great content !
Love your channel❤️
Thanks 😊
Hi, Ruth, great content as always!
Do you know a way to get a user input (by a slicer) and then call the API based on that value?
Exe: User select a radius length in a slicer than you call the API to get the area on the fly
M query parameters, but they don’t work with an api only in direct query. Maybe if you do dataflow first?
@gulherme Pereira Have you somehow made such app in Power BI? If yes, can you give me some advice, how to made it? I try to made it using python, but it only work for definied visuals :(
Hello, what about getting data from an REST API with authentication?
Well, there are around 1M different ways to authenticate so it needs to be managed case by case. Bummer…
This would have been the last channel I would have expected to see a dirty chuck Norris joke on!
Oh no! The masking didn’t work?
I will hit Chuck Norris data creator one day for sure 🤣
Would like to see api calls with differentiere parameters, username, password etc…
This is a tutorial to get started only :)
Great! Thanks Ruth!!
Thanks a lot from colombia
Chuck and myself thank you as well :)
@@CurbalEN jajajaja
😂
Great!! Thanks Ruth!!
🥳