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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
esuing
Helper I
Helper I

Dynamic Subscriptions Error

Hello. I setup a semantic model with a distribution list for the new dynamic subscription function.  I am able to set up the subscription without error, mapping my filters and email addresses.  The semantic model is based off an Excel file we are storing in Sharepoint.  The model updates fine and is working as intended. However, the subscription itself throws an error when running and I cannot determine why or how to fix. This is the error I receive via email when attempting to run the subscription:

 

DataDrivenSubscriptionPreProcessingError

An internal error is preventing the subscription from proceeding: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: OnPremiseModelAccessDenied

 

 

Any thoughts?  Though it says access denied, I do not understand why. I can access and update the model in the workspace, where I have admin rights. 

2 REPLIES 2
GilbertQ
Super User
Super User

Hi @esuing 


Could it be the access denied is to the SharePoint file?

 

I think that as long as all the details are within a single semantic model it should work?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi, GilbertQ.

 

When I connect to the semantic model to create the subscription, it's able to access the fields just fine. I can map them to the Email address and filters for the subscriptions.  I can also perform automatic refreshes on the semantic model without any program. I have a report attached to the model that also works without issue, so if there is an access permission issue, I cannot find it and it doesn't seem to affect anything else.

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 FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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