Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have multiple delta tables in Azure Data Lake Storage Gen2. I would now like to create shortcuts to these delta tables. Instead of doing this manually in the lakehouse, I was wondering if this was possible with code (for example, Python) or an API. It would save a lot of time.
I saw the recent announcement about the Lakehouse API (https://learn.microsoft.com/en-us/fabric/data-engineering/lakehouse-api), but I am not seeing anything about creating shortcuts.
Solved! Go to Solution.
Hi @Anonymous
Thanks for using Fabric Community.
Currently API for creating shortcuts is not yet supported in Fabric. But this is on roadmap.
For more information please refer to this link: Link1
Hope this helps. Please do let us know if you have any further questions.
Good day,
Has this been implemented already?
I have attempted to perform the shortcut creation to Dataverse programatically in Fabric Notebook, however I can not make it work.
Therefore, my question is, has the support for shortcut creation has already been added to the API or not yet?
Just in case, I will add some context to my case. I have created a Link to Microsoft Fabric from my Dataverse environment to a Lakehouse in Fabric. I have removed 1-2 tables in Fabric, thus removing the shortcuts. I want now to add the shortcuts back, but I need to do it programatically.
This is the code that I am using to call the API:
entity = 'actioncard'
url = f"https://api.fabric.microsoft.com/v1/workspaces/{WORKSPACE_ID}/items/{LAKEHOUSE_ID}/shortcuts"
headers = {
"Authorization": f"Bearer {token}",
"Content-Type": "application/json"
}
# create shortcuts for a list of entities
for entity in MISSING_ENTITIES:
print(entity)
payload = {
"name": entity,
"path": f"Tables/{entity}",
"target": {
"dataverse" : {
"deltaLakeFolder": "",
"environmentDomain": DATAVERSE_END_URL,
"tableName": f"{entity}",
"connectionId": CONNECTION_ID
}
}
}
try:
response = requests.post(url, headers=headers, json=payload)
I am getting the following 400 error:
Failed to create actioncard: 400 - {"requestId":"1534w4aa-e00a-4f05-aa9f-d4c5573456c9","errorCode":"BadRequest","moreDetails":[{"errorCode":"RequestBodyValidationFailed","message":"Shortcut target uri /actioncard:Dataverse is malformed."}],"message":"The request could not be processed due to missing or invalid information"}
If the support has been implemented but I am taking the wrong approach, please reffer to the correct documentation.
Thanks a lot in advance.
Hi @Anonymous
Thanks for using Fabric Community.
Currently API for creating shortcuts is not yet supported in Fabric. But this is on roadmap.
For more information please refer to this link: Link1
Hope this helps. Please do let us know if you have any further questions.
User | Count |
---|---|
6 | |
3 | |
2 | |
2 | |
2 |
User | Count |
---|---|
18 | |
17 | |
5 | |
4 | |
4 |