Тёмный

Getting Started With Power BI API (Set Up, Configuration, Examples) 

JJ Power BI
Подписаться 3,4 тыс.
Просмотров 45 тыс.
50% 1

Опубликовано:

 

13 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 47   
@tameimpalan
@tameimpalan Год назад
Freaking amazing video man! Just an advice do the ones that are starting on python... I couldn't set the cred.py file, nor install the package, so i just created the variable with username and password. It's not the best practice to do, but it worked properly, so let the future me worry about secury stuff lol.
@tetzki9962
@tetzki9962 2 года назад
thanks this is helpful. is there a way get query a power bi dataset using this python script?
@gifbfbvhvhdhfhfjffjfnfhfb515
Thank you so much the azure kept returning error 401 and what was missing was turning the azure active directory security off
@MohamedAslamK-mh1wn
@MohamedAslamK-mh1wn Год назад
Wonderful video its work to me, but at the same in my side *Disable Default Security* option not necessary to me just apply ** is enough to me and its work...!, once again thank you so much...
@vtrg16
@vtrg16 10 месяцев назад
Hi!! Can you explain how get the access token with a service principal authentication??
@majidabbasi1552
@majidabbasi1552 2 года назад
thank you for an amazing and detailed video.
@JorgeEscobarMX
@JorgeEscobarMX 8 месяцев назад
Thank you. Great content and now I see how to connect Python to a power bi dataset. I wonder if you can query a power bi dataset as if it is a database?
@JJPowerBI
@JJPowerBI 8 месяцев назад
I have tried, unfortunately, that's not possible currently. Perhaps one day Microsoft will release such API.
@navinrangar2626
@navinrangar2626 Год назад
Hi man, awesome this is. how can we refresh this access token automatically hereafter?
@jcarneiro91
@jcarneiro91 Год назад
Doesn't let me disable security defaults, a permission related message prompts
@JJPowerBI
@JJPowerBI Год назад
That means you probably don't have admin right
@milpatel83
@milpatel83 Год назад
For companies who use Power BI via an Office 365 licence, I assume the setting changes made in Azure would need to come via the IT department?
@jaroslavmarko8627
@jaroslavmarko8627 8 месяцев назад
Hi, thank you for perfect and detailed video. Maybe you can help me with one issue. I fail to authenticate using username and password (I get an "The access policy does not allow token issuance." - which should mean that I need to use MFA - company policy that cannot be avoided). When I use Confidential client then i can get a Access token, but it gets refused by the http call (401 error). Any idea how can I perform a MFA authentication and get a functional token, please? Thanks a lot for your answer.
@muralichiyan
@muralichiyan 2 года назад
Nice keep rocking … We need to buy azure embedded licenses for this ..?
@JJPowerBI
@JJPowerBI 2 года назад
Nope.
@MiguelLP90
@MiguelLP90 Год назад
Excelente video, Muchas gracias
@MHFCLoveOfMyLife
@MHFCLoveOfMyLife Месяц назад
Hey :) Thanks for the detailed video!! When trying to register application I get this error: Error when registering application: ERROR: Request returned Forbidden and graph API request id: {id} Do you know what can be the problem? thanks!
@JJPowerBI
@JJPowerBI Месяц назад
This is has to do with permission issue that that you will need to reach out to your admin to grant you permission.
@MHFCLoveOfMyLife
@MHFCLoveOfMyLife Месяц назад
@@JJPowerBI thanks for the answer !
@MHFCLoveOfMyLife
@MHFCLoveOfMyLife Месяц назад
Hey, If i don't own pbi pro, and my co worker is creating the app our team use, can i use his app client id and secret with my user, in my code, in order to fetch data from the api? will i'll be able to create access token?
@JJPowerBI
@JJPowerBI Месяц назад
I am not sure. You can give it a try.
@user-zt8nn4mb6n
@user-zt8nn4mb6n Год назад
can I have the same implementation code with java
@user-hx5qb8ii3j
@user-hx5qb8ii3j 7 месяцев назад
Is there any additional costs when running requests to API when using pro account?
@JJPowerBI
@JJPowerBI 7 месяцев назад
Currently there is no cost using the API.
@MHFCLoveOfMyLife
@MHFCLoveOfMyLife 2 месяца назад
Hey, Can I use the api without pbi pro?
@JJPowerBI
@JJPowerBI 2 месяца назад
Unfortunately no. Power BI rest API is mostly used to manage power BI online functions.
@ricardojosemunozanaya2347
@ricardojosemunozanaya2347 3 месяца назад
hello bro, i dont know what happened, "ValueError: Public Client should not possess credentials"
@JJPowerBI
@JJPowerBI 3 месяца назад
There is a typo somewhere in your code.
@andresmoreno4726
@andresmoreno4726 Год назад
I am trying with MSAL ConfidentialClientApplication, I am getting the token correctly, but the last part is not working for me... Do I need to change the way I build my endpoint? Or How I know which is my endpoint? Hope you could solve my doubt c:
@mostafamoustaghni6980
@mostafamoustaghni6980 4 месяца назад
I have the same issue, did you solve it?
@rushatpatil3200
@rushatpatil3200 6 месяцев назад
Is there any PowerBI rest API, to read data from a visual?
@JJPowerBI
@JJPowerBI 6 месяцев назад
Can you be more specific?
@morinho96
@morinho96 5 месяцев назад
Hello, when I check the reponse to the access token, I see that the scope returned in my access token is 00000002-0000-0000-c000-000000000000, and not the actual scopes defined in the app. Do you have any idea why ? Thanks a lot !!
@JJPowerBI
@JJPowerBI 5 месяцев назад
Hard to tell. But most likely it when you set up the Azure app, one of the option is not set correctly.
@morinho96
@morinho96 5 месяцев назад
@@JJPowerBI Thank you for your response. The username and password you used are admin credentials ? I am trying to connect without using a user credentials...
@amruthamu9967
@amruthamu9967 11 месяцев назад
HI Sir, while running response = client.acquire_token_by_username_password(username=username, password=password, scopes= scopes) I am getting below error: 'WsTrust server returned error in RSTR: {'reason': 'Authentication failed', 'code': 'wst:FailedAuthentication'}' any idea how can we resolve this?
@JJPowerBI
@JJPowerBI 11 месяцев назад
I would probably Google the error.
@satishk1464
@satishk1464 Год назад
i am getting 404 error while accessing the data
@JJPowerBI
@JJPowerBI Год назад
404 error is usually due to address is not found. Maybe sure your app is set up correctly.
@ganeshghuge3405
@ganeshghuge3405 Год назад
enable security defaults is by default in my case still getting error. please help. getting an error 'error': 'invalid_grant', 'error_description': "AADSTS65001: The user or administrator has not consented to use the application.
@AntrikshSharma
@AntrikshSharma Год назад
At 5:45 see the option "Grant admin consent for ...." click on that and grant it.
@ganeshghuge3405
@ganeshghuge3405 Год назад
@@AntrikshSharma Thanks much man. The domain name isn't verified that's why I was not getting an option to grant. I did it by visiting admin.microsoft.com and it's working now.
@newblog7540
@newblog7540 Год назад
Hi, I'm on Step 1: Generating Access Token and get this error: ImportError: cannot import name 'username' from 'cred' (C:\Users\talha.farooq\AppData\Local\Packages\PythonSoftwareFoundation.Python.3.10_qbz5n2kfra8p0\LocalCache\local-packages\Python310\site-packages\cred\__init__.py) I have installed cred module Could you please let me know what am I missing?
@JJPowerBI
@JJPowerBI Год назад
Create a file called cred.py. Inside cred.py, create two variables "username" and "password".
@ananthkrishnabattepati
@ananthkrishnabattepati Год назад
@@JJPowerBI What are the values of this username and password? are they blank variables or should we send any credentials to it?
@HallofWisdom
@HallofWisdom Год назад
--- 7:57 without sharing your username or password, can you show us the 'cred' script? ---11JUN23
@JJPowerBI
@JJPowerBI Год назад
Basically just defining two variables. For example, username = 'xyz' password = 'abc'
Далее
Decompress small game, have time to play it!
00:35
Просмотров 10 млн
Аушев, Путин, «пощечина»
00:56
Просмотров 803 тыс.
How Strong is Tin Foil? 💪
00:26
Просмотров 48 млн
Power BI API Service Principal Account
29:54
Просмотров 17 тыс.
Power BI REST API; What it is and Why it is Important
12:27
Intro to Power BI REST API
1:36:29
Просмотров 20 тыс.
Power BI in Python | Authentication
30:30
Просмотров 14 тыс.
Create A Python API in 12 Minutes
12:05
Просмотров 632 тыс.
Decompress small game, have time to play it!
00:35
Просмотров 10 млн