Solving an error in my report query

0 votes
If you normally have an error when you try to update, or refresh a query, the system shows you what the error is.

For examples duplicates, of errors in the file you have imported.

However this time I have an error, and when you click on the 'show error', the table I get is empty.

I will attach views:

1) view of the original error

2)after I click view view error, this is the screen I get

All the data that is imported in the other tables worked, this table is a combined table of all above years together.

ex: = Table.Combine({#"2013", #"2014", #"2015", #"2016", #"2017"})

There was no error first, than we updated some data in the sources, all was refreshed without errors exept this error in the combined table called 2013-2017
Nov 20, 2020 in Power BI by anonymous
• 10,520 points
680 views

1 answer to this question.

0 votes

This situation typically happens when you have data that doesn't meet the column type of your table in Power Query.

An example would be decimal numbers in a column with type Int64.Type (Whole Numbers).

Power Query allows this (so there is no error in your query editor, nor in your error report), but when loading the data, errors are reported.

It may require some searching to locate the issue.

Specializing in Power Query Formula Language (M)

answered Nov 20, 2020 by Gitika
• 65,890 points

Related Questions In Power BI

0 votes
1 answer

Can I create a Power BI report in Office 365 without my locally installed Office Excel?

Yess!! You can achieve this by using ...READ MORE

answered Sep 26, 2018 in Power BI by Kalgi
• 52,350 points
881 views
0 votes
1 answer

Power Query Web request results in “CR must be followed by LF” Error

What I think is, it might look ...READ MORE

answered Oct 29, 2018 in Power BI by Shubham
• 13,490 points
1,864 views
0 votes
1 answer

Direct Query Report gateway connection error

There can be many reasons for this ...READ MORE

answered Nov 19, 2020 in Power BI by Gitika
• 65,890 points
1,310 views
0 votes
1 answer

How to add an image to power bi report – power bi web

There are visuals (e.g. table) that can ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 52,350 points
1,351 views
0 votes
1 answer

Unable to Connect to import or direct query reports

Check your cached data sources. Once in ...READ MORE

answered Nov 20, 2020 in Power BI by Gitika
• 65,890 points
1,103 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
998 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
864 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
1,210 views
0 votes
1 answer

Error Error on Data load when open report in server "An error has occurred"

The problem you can solve by edit this ...READ MORE

answered Nov 16, 2020 in Power BI by Gitika
• 65,890 points
1,521 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,520 points
78,777 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP