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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
PBIUsers
Frequent Visitor

Fabric Notebook Scheduled Run Query

Hello Fellow Pbi users,

I've developed a Fabric notebook scripts to refresh a specific table of a Power BI dataset using the semantic link. Please refer to the attached screenshot for the detailed code. I can successfully run the code and refresh the table using the notebook. However, when I schedule it to run automatically, it fails to work.

Any pointers would be greatly appreciated.

Screenshot of the Workspace Environment that is used for the above notebook is also attached below along with the recent history of the failed scheduled run. 

PS: Fairly new to notebooks. Using fabric notebooks for the first time. Got the semantic link scripts from a post in Linkedin  Fabric Notebook : Script used for refreshing single table of a Power BI datasetFabric Notebook : Script used for refreshing single table of a Power BI datasetFabric Workspace Environment used for the NotebookFabric Workspace Environment used for the NotebookScheduled Run screenshot.Scheduled Run screenshot.

Thank you, 

5 REPLIES 5
lbendlin
Super User
Super User

Create a pipeline, and include the notebook in it.

Hello Ibendlin, 

I tried setting up a pipeline with the above notebook, but things weren't working. Then, I figured out that once I ditched the "% pip" command, everything just fell into place. I was able to schedule the notebook to run on its own and also with the pipeline after that.

Thanks for the suggestion!

Regards,

hi pbiuser 

 

Thanks a lot for your great Idea to refresh a pbi model via semantic link python functions on a fabric nootebook

 

I Guess WE dont need to conect to the pbi  WS  like on python ( Access token via AAD service principal because the notebook IS on the same ws , right  ? 

 

Similar for a data Factory pipeline on the same Fabric  ws , no nee to connect to internal artifacts ? 

 

My best  

Hey Chris,

If the semantic model is in the same workspace and you've got the right permissions, no need to authenticate. But I'm a bit stumped on how to handle it when the model is in a different workspace. Any thoughts? Let me know if you come up with any ideas.

Cheers, 

You get the authentication "for free"  but these tokens expire.  You will have to renew them from time to time.

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!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.