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: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

tprince54

Data Alignment Errors With SMSS Direct Query

Submitted by on ‎04-24-2018 12:32 PM

Hello,

 

I am experiencing an issue when refreshing a data set in Power BI using SSMS as a direct query.  When I refresh, I will have multiple sets of data in columns shift without retaining their correct column header.  For example, we have two columns names: Column Header 1 and Column Header 2.  Column Header 1 contains binary data set (either 0 or 1) and Column Header 2 contains analog data set (range from 0 to 100).  If I refresh, it causes the analog data set (range from 0 to 100) to be under the Column Header 1 and the binary data set is now under Column Header 2.  Everytime I refresh, the data in the columns switch back and forth.  I have double checked my SQL sources are correct and they all contain the correct data with no errors when querying from SSMS.  I have also tried making a new data table and new report and neither have resolved this issue.  Thanks.

Status: New
See more ideas labeled with:
1 Comment (1 New)
Comments
v-qiuyu-msft
Community Support
Community Support
‎04-25-2018 10:33 PM

Hi @tprince54,

 

Does the issue happen on Power BI service or Power BI desktop? 

 

What do you mean about "Column Header 1 contains binary data set (either 0 or 1) and Column Header 2 contains analog data set (range from 0 to 100)"? Would you please share script to create sample report in SSMS? 

 

Best Regards,
Qiuyun Yu 

Idea Statuses