Importing Lakehouse table into PowerBI for up to date data

[ramankr48]

Hi Community member,

I have designed one poc on real time intelligence, where i am taking stock data which is internal of fabric, by using eventstream ingesting the data into the lakehouse table named stock(destination). Later I'm importing the stock table from the lakehouse into the power bi desktop using direct lake option (which brings the live data from the delta table of lakehouse), but in the data pane on the right side,  not able to see any table. the same if i am trying to import from warehouse option in power bi i am getting that table.

Can you guys help me with this or any suggestion will be halpful.

[Anonymous]

Hi @ramankr48 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[Anonymous]

Hi @ramankr48 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[Anonymous · Accepted solution]

Hi @ramankr48 

In Microsoft Fabric, a Lakehouse automatically creates a default semantic model in Direct Lake mode. However, new tables added to the Lakehouse may not automatically sync with the default semantic model unless the "auto-sync" option is enabled. If this is disabled, the "stock" table may not be included in the semantic model, causing it to be invisible in Power BI Desktop.

Ensure the "stock" table is included in the default semantic model by enabling auto-sync.

• In the Fabric workspace, navigate to the Lakehouse’s SQL Analytics Endpoint.
• Click "Manage default semantic model" in the Reporting ribbon.
• Check if the "stock" table is listed. If not, add it manually or enable the "Auto-sync" option to automatically include new tables from the Lakehouse. This can be found in the semantic model settings under "Keep your Direct Lake data up to date."
• After enabling auto-sync, wait a few minutes for the table to appear in the semantic model. You can also trigger a manual sync by refreshing the SQL Endpoint

 If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.

[Anonymous]

Hi @ramankr48 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[Anonymous]

Hi @ramankr48 
Thank you for reaching out microsoft fabric community forum.
 If you're using Eventstream to write into a Lakehouse and connecting via Direct Lake in Power BI, make sure the table is a "Default" Lakehouse table under the Tables section, as only managed Delta tables are supported.

Check that the table has data and the schema is properly registered — empty or newly created tables might not show up.
Restart Power BI Desktop to clear any cached metadata.  Direct Lake isn't truly real-time, so if you need live updates, Eventhouse with Real-Time Dashboards might be a better fit. If the table appears under Warehouse but not Direct Lake, try re-creating it through the Lakehouse UI to ensure the format is compatible.

If this solution helps, please consider giving us Kudos and accepting it as the solution so that it may assist other members in the community
Thank you.

[ramankr48]

stock_lh is the table where i am ingesting the data and it is managed table and it has the data also

if it is near real time also it will work for me, for now

and in real time dashboard we don't have multiple visualisation right, we have just limited one.

but still not able to connect the LH table into powerbi

[lbendlin]

Lakehouse is not real time. For that you would need to use an Eventhouse.