PowerBI data refresh using Python

Question

PowerBI data refresh using Python

Shreeti Saha 0

We are trying to refresh data of PowerBI using Python(Azure Data Bricks). We have created App Registration service with all the necessary access. We are able to create the authentication token successfully, but unable to refresh the data. Getting unauthorized error. User's image

PRADEEPCHEEKATLA 90,596 Reputation points

2023-10-10T09:37:37.72+00:00

@Shreeti Saha - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
PRADEEPCHEEKATLA 90,596 Reputation points

2023-10-13T09:13:10.2833333+00:00

@Shreeti Saha - Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
PRADEEPCHEEKATLA 90,596 Reputation points

2023-10-19T09:02:54.53+00:00

@Shreeti Saha - Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

PRADEEPCHEEKATLA 90,596 Reputation points

2023-10-10T09:37:37.72+00:00

@Shreeti Saha - We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
PRADEEPCHEEKATLA 90,596 Reputation points

2023-10-13T09:13:10.2833333+00:00

@Shreeti Saha - Following up to see if the above suggestion was helpful. And, if you have any further query do let us know.
PRADEEPCHEEKATLA 90,596 Reputation points

2023-10-19T09:02:54.53+00:00

@Shreeti Saha - Just checking in to see if the below answer helped. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

@Shreeti Saha - Thanks for the question and using MS Q&A platform.

It sounds like you are encountering issues with refreshing data in Power BI using Python in Azure Databricks. Specifically, you are able to create the authentication token successfully, but are encountering unauthorized errors when trying to refresh the data.

To resolve this issue, you can try the following steps:

Check if the App Registration service has the necessary permissions to refresh the data in Power BI. Specifically, the service needs to have the "Dataset.ReadWrite.All" and "Report.ReadWrite.All" permissions. You can check this by going to the Azure portal and navigating to the "API permissions" section of the App Registration service.
Check if the authentication token is being passed correctly in the Python code. Specifically, you need to ensure that the token is being passed in the "Authorization" header of the HTTP request. You can check this by printing the HTTP request headers in your Python code.
Check if the HTTP request is being sent to the correct endpoint. Specifically, you need to ensure that the request is being sent to the correct endpoint for refreshing the data in Power BI. You can check this by reviewing the Power BI REST API documentation.
Check if the HTTP request is being sent with the correct HTTP method. Specifically, you need to ensure that the request is being sent with the correct HTTP method for refreshing the data in Power BI. You can check this by reviewing the Power BI REST API documentation.
Check if the HTTP request is being sent with the correct content type. Specifically, you need to ensure that the request is being sent with the correct content type for refreshing the data in Power BI. You can check this by reviewing the Power BI REST API documentation.

For more details, refer to Power BI thread which addressing similar issue.

I hope this helps! Let me know if you have any further questions.

Share via

PowerBI data refresh using Python

1 answer

Your answer