'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Can a Power BI Dataflow Use a OneLake Data Hub Semantic Model?
Question details
Determine if a Power BI semantic model opened from the OneLake data hub can be utilized as a direct source for building a Power BI dataflow.
- Product
- Power BI
- Device & OS
- not provided
- Scenario
- Configuring data sources for a new or existing Power BI dataflow.
- Observed behavior
- Users are uncertain if connection strings beginning with pbiazure:// or live Excel connections imply that the semantic model is supported as a dataflow source.
Ensure you have the appropriate workspace access permissions in Microsoft Fabric and verify the latest Power BI dataflow connector list in the official documentation before configuring new connections.
Connect Dataflow to the Underlying Data Source
If the OneLake semantic model is not natively available as a dataflow source, bypass the model and connect your dataflow directly to the original data source.
A live Excel connection to a semantic model does not guarantee that the model can be used as a direct source for a Power BI dataflow. Relying on the underlying data source is the most stable and officially supported method.
Check the semantic model settings to identify the original underlying databases or files (e.g., SQL Database, SharePoint, Dataverse) that feed the model.
Navigate to your Power BI workspace, select 'New', and click on 'Dataflow'.
Click 'Add new tables' and search for the connector that matches your underlying data source instead of searching for the semantic model.
Enter your credentials for the original data source, configure your transformation steps in Power Query, and save the dataflow.
Use the Azure Analysis Services Connector
Try utilizing the Azure Analysis Services connector using the model's XMLA endpoint connection string.
Enhance Your Data Analysis with WPS Spreadsheet
While Power BI and Microsoft Fabric handle complex enterprise dataflows, you may need a reliable desktop application to analyze exported datasets, build pivot tables, and share reports quickly. WPS Office offers a lightweight, highly compatible spreadsheet solution for your everyday data tasks.
Frequently Asked Questions
Does a live Excel connection mean a semantic model can be used in a dataflow?
No. The ability to establish a live connection to a semantic model in Excel does not necessarily mean that the model is supported as a direct source for a Power BI dataflow.
What does a connection string starting with pbiazure:// represent?
A pbiazure:// connection string represents an XMLA endpoint connection to a Power BI dataset or semantic model hosted in the Power BI service.
Where can I get help if my Power BI dataflow fails to connect?
For issues specifically related to Power BI dataflows or Microsoft Fabric connections, it is best to post your questions in the Microsoft Fabric or Power Platform community forums.
