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 19, 2020 in Power BI by anonymous
• 10,420 points
54 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 19, 2020 by Gitika
• 65,870 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,310 points
279 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,480 points
646 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,870 points
92 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,310 points
639 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 19, 2020 in Power BI by Gitika
• 65,870 points
106 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,310 points
227 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,310 points
183 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,310 points
233 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 15, 2020 in Power BI by Gitika
• 65,870 points
74 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,420 points
18,392 views