Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
AizatHashim
Frequent Visitor

Unable to Refresh Dataset in Power BI Service_PowerBINotAuthorizedException

Hi everyone,

 

I am seeking your help to solve my issue of error message that I receive when I am refreshing my dataset in Power BI Service as follows:

 

Data source error: [ValidateMarkupTags][ccon]DataSource.Error: An error happened while reading data from the provider: '[ccon]{"error":{"code":"PowerBINotAuthorizedException","pbi.error":{"code":"PowerBINotAuthorizedException","parameters":{},"details":[],"exceptionCulprit":1}}}[/ccon]'. DataSourceKind = [ccon]AIFunctions[/ccon]. DataSourcePath = [ccon]AIFunctions[/ccon]. [/ccon]. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: RATING_Key Phrases_1.
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: 76bf4b20-f3cf-4125-af74-d095a70d1ca8
Request ID: 0e13f9f1-e3cb-2b2e-db15-3c6dba78f08d

 

I have upgraded my Power BI account from Pro to Premium Per User and am still receiving the error message as above.

 

Highly appreciate your kind support everyone!

 

Regards,
AH.

1 ACCEPTED SOLUTION

Hi @Anonymous ,

 

Thank you for your suggested solution. Currently, I have all the access to the data source and thus the premission to the data source was not the issue.

 

Right now, my issue had resolved. It was the workspace license that was not assigned correctly. Since I am using AI function (Text Analytics) in my Power BI report, my workspace settings should be assigned to Trial version of Microsoft Fabric so that I am able to use AI function when refreshing the dataset via Power BI Service.

 

Appreciate your kind feedback again mate and hope this solution will help the others.

 

Thank you and have a good day ahead!

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Hi @AizatHashim ,

The error “PowerBINotAuthorizedException” usually occurs if you don’t have proper permissions to perform the action. As you are trying to refresh your dataset in Power BI Service, make sure to grant the appropriate permissions to your data source and your service principal.

Some of the steps you can try are:

Share the dashboard with yourself in Power BI Service. This is assuming you have the access to share the dashboard within Power BI.
Check the regional settings of your system and make sure they match with the Power BI Service.
Use the Power BI REST API or PowerShell cmdlets to create, update, or delete deployment pipelines and workspaces.
Use Azure DevOps to automate the deployment of Power BI content using pipelines and tasks.

.net - PowerBI not authorized exception - Stack Overflow

powerbi - Unauthorized (401) Power BI Embedded using the samples Node and .NET - Stack Overflow

Solved: PowerBINotAuthorizedException error - Power Platform Community (microsoft.com)

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

Hi @Anonymous ,

 

Thank you for your suggested solution. Currently, I have all the access to the data source and thus the premission to the data source was not the issue.

 

Right now, my issue had resolved. It was the workspace license that was not assigned correctly. Since I am using AI function (Text Analytics) in my Power BI report, my workspace settings should be assigned to Trial version of Microsoft Fabric so that I am able to use AI function when refreshing the dataset via Power BI Service.

 

Appreciate your kind feedback again mate and hope this solution will help the others.

 

Thank you and have a good day ahead!

Hi @AizatHashim 
I was experiencing the same issue and I followed your advice to update the workspace to the trial version of fabric and it worked. Thank you for your recommendation. 

Best wishes, 
N

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.