Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,694 questions
Changing source of existing semantic model to lakehouse delta tables
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 44%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESP%3C/text%3E%3C/svg%3E)
Sunay Pistulkar
5
Reputation points
Hi,
We newly created a lakehouse in the existing power bi workspace, and I want to change the source of the semantic model to the lakehouse. But it is throwing the following error.
"Semantic model connectivity with the XMLA endpoint"
'XMLA endpoint': it needs multiple approvals, we want to find the workaround, because existing models are very critical and complicated, and creating new ones with precision would be a bigger task.
Please let me know if you have any suggestions or solutions.
Thanks!!
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu 12,620 Reputation points Microsoft Vendor2024-07-26T07:42:52.02+00:00 Thanks for the question and using MS Q&A platform.
As I understand you are trying to change the source of the semantic model in Power BI to the newly created lakehouse, but you are encountering an error related to the XMLA endpoint.
The XMLA endpoint is used to connect to Analysis Services models in Power BI, and it requires multiple approvals to be enabled. If you are unable to enable the XMLA endpoint, there are a few workarounds you can try:
- Use DirectQuery: If your data is stored in a supported data source, you can use DirectQuery to connect to the data source directly from Power BI. This will allow you to create a semantic model without using the XMLA endpoint.
- Use Power BI dataflows: Power BI dataflows allow you to create a semantic model using Power Query, which is a data transformation and cleansing tool. You can connect to your lakehouse using Power Query and create a semantic model using the dataflows feature.
For more information refer the below articles:
- XMLA endpoint
- Troubleshoot XMLA endpoint connectivity
- Analytics end-to-end with Azure Synapse
- Deploy an End-to-End Azure Synapse Analytics and Power BI Solution using CMS Medicare Data
- Enterprise Data Warehouse Architecture
I hope this helps! Let me know if you have any further questions.
Sign in to comment