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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
andyemiller
Frequent Visitor

Warehouse Parquet Format

I utilized a data pipeline to copy a lakehouse into a warehouse. Everything transferred properly, but within 30 minutes, the transferred tables were converted into a Parquet format. 

 

When you view the cloud-based warehouse, you see standard tables from the lakehouse. See the first image. 

 

andyemiller_0-1700135982846.png

 

I can also see the stored procedures and views that were created within the warehouse. However, PowerBI and any SQL endpoint is not able to reference the aforementioned tables. Here are the tables on the SQL endpoint. 

 

andyemiller_1-1700136098611.png

 

Even the earlier pipeline cannot find the stored procedures, tables, and views that are available in the warehouse. Here is the error message on the copy activity. 

 

andyemiller_2-1700136245340.png

 

Would someone be able to assist me with this issue? I need to retain the original file structure, views, and stored procedures within the view.

 

 

 

 

4 REPLIES 4
andyemiller
Frequent Visitor

Once again, the issue noted above has reemerged. 

The cloud-based warehouse has the correct table structure. 

andyemiller_0-1700154973445.png

However, the SQL endpoint has the Parquet file structure. 

andyemiller_1-1700155068616.png

Once again, this breaks the reporting tools. Is anyone able to assist me? 

Hi @andyemiller ,

Thanks for using Fabric Community.

Apologies for the issue you have been facing. I would like to check are you still facing this issue?
As we know currently Fabric is in preview it is difficult to tell what could be the reason for this performance. I would request you to wait for sometime and try again as it may be due to some outage issue.

If the issue still persists, please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Hope this helps. Please let us know if you have any other queries.

@v-gchenna-msft, yes, I am still experiencing the issue. The timing is intermittent and inconsistent.  I have submitted a ticket (2311160040010477) with the related information. 

andyemiller
Frequent Visitor

I cannot explain it, but the issue was corrected this morning within minutes of posting this message. There was, however, a real issue between 12:00 pm EST yesterday and 5:00 am EST today. 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Fabric Monthly Update - February 2024

Check out the February 2024 Fabric update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.