- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 dataset
Fabric Workspace Environment used for the Notebook
Scheduled Run screenshot.
Thank you,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Create a pipeline, and include the notebook in it.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You get the authentication "for free" but these tokens expire. You will have to renew them from time to time.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-11-2024 01:42 PM | |||
09-19-2024 05:59 AM | |||
01-17-2024 02:09 AM | |||
12-19-2024 07:09 PM | |||
07-24-2024 12:49 PM |