Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

aflores

Excel Connect

Submitted by on ‎06-22-2018 08:14 AM

Created an excel connected to my Power BI report. The problem I have is that for some columns, the numbers in the excel don't match the Power BI report. I have no clue on what is going on.

 

Any Ideas?

Status: Needs Info
See more ideas labeled with:
3 Comments (3 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎06-24-2018 07:34 PM

Hi @aflores,

 

Do you use the Power BI publisher for Excel add-in in Excel to connect to Power BI datasets? 

 

pbi_excel_publisher_ribbon.png

 

 

Which data source does the Power BI dataset get data from? Which data type of the column has the issue in Excel? When you mention "the numbers in the excel don't match the Power BI report", please check if there are any slicers or filters set on Power BI report affect the results. 

 

Please share detail information so we can try to test on our side. 

 

Best Regards,
Qiuyun Yu

Vicky_Song
Impactful Individual
Impactful Individual
‎06-24-2018 07:36 PM
Status changed to: Needs Info
 
aflores
Frequent Visitor
‎06-25-2018 05:56 AM

Hi Qiuyun Yu,

Thanks for your reply. Yes, I am Using the Power BI Publisher. And you just solved my problem. I started reviewing if some filters were aplied. That was the reason!

 

Thnk You!  Arturo

Idea Statuses