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: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

bhalicki

Tables in PowerQuery editor do not reflect PowerBI data model using Dataverse connector

Submitted by Helper IV on ‎06-30-2023 11:58 PM

I have imported a table from Dynamics using the Dataverse connector.  I have transformed one of the tables in PowerQuery, which includes renaming the columns.  When I view the table in PowerBI data model, some columns reflect the display name.

 

Clearing the cache and reimporting the data does not help.

 

This appears to have started in May 2023. 

 

September 2022 is fine, April 2023 is fine, May 2023 is broken, June 2023 is broken.

Status: Delivered
See more ideas labeled with:
24 Comments (24 New)
Comments
Anonymous
Not applicable
‎08-03-2023 06:27 PM

Hi  @bhalicki 

This issue has been fixed . Please check it in PowerQuery .

 

Best Regards,
Community Support Team _ Ailsa Tao

bhalicki
Helper IV
Helper IV
‎08-03-2023 06:30 PM

Hi @Anonymous ,

 

The issue is with PowerBi Desktop also - do you mean the issue has been fixed and part of the August 2023 release?  

Thanks and regards,

Ben.

FredQ
Frequent Visitor
‎08-20-2023 10:47 PM

This has not been fixed.  It is ludicrous that Microsoft would break such a fundamental thing!

DemoFour
Responsive Resident
Responsive Resident
‎02-12-2024 05:56 AM

What is the fix on this issue @Anonymous  please. 

As I have just connected to a Dataverse connector and some of my fields names have reverted back to the Dataverse names after I changed then in PQ of Desktop! 

AlyssaL036
Frequent Visitor
‎09-25-2024 07:55 PM

The bug is back and is affecting reporting with Dataverse again... very irritating. Is there a fix coming soon?

DemoFour
Responsive Resident
Responsive Resident
‎09-26-2024 01:34 AM

@AlyssaL036 you are right, I noticed this in a report I am building this week, it is not going into production yet, but I did see that the Dimension tables all had the dataverse table names not the names I had given them in PQ! 

@Anonymous Should this be logged as a new issue, as a fix was issued? 

EAD
New Member
‎11-13-2024 12:47 AM

Hi All,

I am experiencing the same issue now.. if this is a bug it's back
@v-yetao1-msft : Any advise, recommendations or solutions

bhalicki
Helper IV
Helper IV
‎11-13-2024 01:13 AM

Hi @EAD , what version of PowerBi (Desktop) are you using?  Which connector are you using?  I am using the latest (Version: 2.137.1102.0 64-bit (October 2024)) and not experiencing this issue any longer.

Kind regards,

Ben.

EAD
New Member
‎11-13-2024 01:23 AM

Hi @bhalicki ,

Using Version: 2.137.1102.0 64-bit (October 2024), I tried rolling back to the September release.

Only expereince this issue with Dataverse, for all other data sources the standard rename column step works.
Tested ( Excel & SQL ).

Any new reports the standard rename step does not work for Dataverse.
Old datasets or reports the rename step stops working as soon as you make a change.

Note:  For the exisiting Datasets / Reports, these were working fine until last month
The change mentioned was, removed a column, saved and published

AlyssaL036
Frequent Visitor
‎11-13-2024 08:28 AM

Since Microsoft doesn't seem to want to reply to this old thread, I've made a new post detailing the issue hoping it will help!
Dataverse Columns Renamed in Power Query Show Display Name After Close and Apply

Idea Statuses