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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
pjose
Helper I
Helper I

Error while applying the queries from Query Editor or while loading the data

Hi,

I am loading data from an excel file which contains many worksheets. My source looks like this.

pjose_0-1608239525342.png

And then its been converted into single queries like below.

 

pjose_3-1608239837436.png

All of the striked tables above has the same schema and the same steps are applied automatically while loading. If I try to load these tables/apply queries one by one, it works fine, but if I try to do load them all together or try to apply the queries after listing down all the tables like in the picture above it fails and give different errors each time like below.

pjose_5-1608240428720.png

 

But all of these tables looks fine in the query editor and can be loaded or applied queries individually.

 

Can anyone help me understand whats going on here?

 

Thanks!

 

 

 

2 REPLIES 2
PhilipTreacy
Super User
Super User

Hi @pjose 

The key didn't match any rows in the table indicates a column name in your Excel table has changed, or a worksheet name has changed.  I can't tell which without access to the data so you will have to go through the query and check where the error is being generated.

 

The downloade data is HTML.....  I see this when a JSON request is made and the server returns HTML.  Are you requesting JSON anywhere in the query?  Your mage shows that you are trying to parse the Web.Contents as an Excel Workbook.  If this web request fails, it may return an HTML error page - you need to test for this.  You could wrap the step in try ... otherwise and check the Web.Contents returns what you expect. If it doesn't then you can end the query.
if you are still having issues please post your M code.

Regards

Phil


If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


amitchandak
Super User
Super User

@ImkeF , can you help on this

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.