Forum Discussion
Python script module not found
- Anonymous4 years ago
Hi Anonymous ,
1. Python script works well in Power BI Desktop, but will show error in Power BI Service.
I think you have unsupported Python packages versions.
Please go to this link:Create visuals by using Python packages in the Power BI service and install PowerBI supported Python packages versions.
2. How can I find my <Access Token> and other parameters as it is described in the following code?
Report ID is the code after/report/ in your report url.
Embed Url is the code Power BI will provide to you when you use embed.
Get Access token in Power BI Desktop:
() => let body = "client_id=" & #"App ID" & "&scope=https://analysis.windows.net/powerbi/api/.default&client_secret=" & #"App Secret" & "&grant_type=client_credentials", Data= Json.Document(Web.Contents("https://login.microsoftonline.com/"& TenantID & "/oauth2/v2.0/token/", [Headers=[#"Content-Type"="application/x-www-form-urlencoded"], Content=Text.ToBinary(body)])), access_token = Data[access_token] in access_tokenOR
() => let body = "&grant_type=Password&resource = https://analysis.windows.net/powerbi/api &client_id=*****&username=*****&password=*****", Data=Json.Document(Web.Contents("https://login.microsoftonline.com/common/oauth2/v2.0/token/", [Headers=[#"Content-Type"="application/x-www-form-urlencoded"], Content=Text.ToBinary(body)])), access_token = Data[access_token] in access_tokenThen you can replace bear token by the access token parameter.
It will refresh every time your refresh your report.
Video: How to get access token and call Rest API by dynamic access token in Power BI Desktop? (5:30 to 9:30)
all Power BI Rest API with Dynamic Access Token From Power BI Desktop |Power BI Rest API
3.Can i select a specific page to visualize without showing the whole report every single time or a specific component of a page like (Pie chart, table, etc ...) ?
For reference:
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
1. Python script works well in Power BI Desktop, but will show error in Power BI Service.
I think you have unsupported Python packages versions.
Please go to this link:Create visuals by using Python packages in the Power BI service and install PowerBI supported Python packages versions.
2. How can I find my <Access Token> and other parameters as it is described in the following code?
Report ID is the code after/report/ in your report url.
Embed Url is the code Power BI will provide to you when you use embed.
Get Access token in Power BI Desktop:
() =>
let
body = "client_id=" & #"App ID"
& "&scope=https://analysis.windows.net/powerbi/api/.default&client_secret=" & #"App Secret"
& "&grant_type=client_credentials",
Data= Json.Document(Web.Contents("https://login.microsoftonline.com/"& TenantID & "/oauth2/v2.0/token/",
[Headers=[#"Content-Type"="application/x-www-form-urlencoded"], Content=Text.ToBinary(body)])),
access_token = Data[access_token]
in
access_token
OR
() =>
let
body = "&grant_type=Password&resource = https://analysis.windows.net/powerbi/api
&client_id=*****&username=*****&password=*****",
Data=Json.Document(Web.Contents("https://login.microsoftonline.com/common/oauth2/v2.0/token/",
[Headers=[#"Content-Type"="application/x-www-form-urlencoded"], Content=Text.ToBinary(body)])),
access_token = Data[access_token]
in
access_token
Then you can replace bear token by the access token parameter.
It will refresh every time your refresh your report.
Video: How to get access token and call Rest API by dynamic access token in Power BI Desktop? (5:30 to 9:30)
all Power BI Rest API with Dynamic Access Token From Power BI Desktop |Power BI Rest API
3.Can i select a specific page to visualize without showing the whole report every single time or a specific component of a page like (Pie chart, table, etc ...) ?
For reference:
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.