cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Data loaded into Power BI from AzureHdinsight is not matching with the actual data of AzureHdinsight

Hi All,

Please help me with the below issue which I am facing from last week 

Data is coming from AzureHdInsight and the connectivity mode is Import .

I have imported one table from hive into Power BI. didnt peformed any transfermations and didnt calculated any column and measures. just imported the table. When I compare the Power bi data with the actual data of Hive it is not matching. 

Below query ran in the database

select * from CR_Table

where date key = 20200731 and

Value_type = "C" 

O/P

Date KeyCode Value Type
20200731" "C
20200731CR_code_7C

For the same selection in Power BI I am getting the below result, Which is wrong.

 

Date KeyCode Value Type
20200731" "C
20200731CR_code_1-6C
20200731CR_code_7C

Cleared chahce and Tried many ways still getting the same result in Power BI . Please help me to resolve this issue.

3 REPLIES 3
Highlighted
Super User IX
Super User IX

Re: Data loaded into Power BI from AzureHdinsight is not matching with the actual data of AzureHdins

@YasmeenShaik , what is the value of date key for

CR_code_1-6 C

 

At the source. Need to check what came wrong to power BI. Or C have space there and got removed in power BI



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
New Member

Re: Data loaded into Power BI from AzureHdinsight is not matching with the actual data of AzureHdins

Hi,  Thank you for your response.

 

Value of date key  for CR_code_1-6 is 20200731.

Problem is not with spaces. value_type "C" doesn't contained any space.

Highlighted
New Member

Re: Data loaded into Power BI from AzureHdinsight is not matching with the actual data of AzureHdins

Any Ideas Please ....

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors