Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
ALHU
Frequent Visitor

Lakehouse SQL Point shows different Data from Notebook SQL

Hello,

 

My problem is then when i'm overwriting an existing Lakehouse Table with a Datapipeline. The correct content is shown when i querying the sql endpoint. However when i want to query the content with a notebook using "Select * From" it shows me the old Data. It used to work until about 2 weeks ago. Does anybody has some suggestion for me?

Thank you for your Help!

1 ACCEPTED SOLUTION
ALHU
Frequent Visitor

Hi Guys,

 

Thank you for your answers!

They issue was when not using a schema for the copy job, which i adjusted in the json editor.

View solution in original post

5 REPLIES 5
GilbertQ
Super User
Super User

Hi @ALHU 

 

Can you make sure that you are using SparkSQL or PySpark to ensure that you are reading the data from the latest version of the Parquet file?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

ALHU
Frequent Visitor

To provide more Details i have a job that copies Table A from a sql database to my BronzeLakehouse.A in MS Fabric. When i use SELECT * FROM BronzeLakehouse.A in my SQL Endpoint view get the expected results, however when i connect my Notebook to BronzeLakehouse and try to use spark.sql("SELECT * FROM BronzeLakehouse.A") it does not work as it used to be 2 weeks ago

ALHU
Frequent Visitor

Hi Guys,

 

Thank you for your answers!

They issue was when not using a schema for the copy job, which i adjusted in the json editor.

Hi @ALHU,

 

Thanks for sharing the solution! Please consider marking your reply as the accepted solution this will help other community members who might encounter the same issue.

Thank you.

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

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.