Forum Discussion

Rajesh4655TREX's avatar
Rajesh4655TREX
New Member
4 years ago
Solved

Power BI dataset refresh issue

When i am trying refresh the daraset document in poewrBI . getting below mentioned error. Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GW...
Need Help
  • OliT's avatar
    OliT
    4 years ago

    Hi Rajesh4655TREX 

    >> {"code":"Microsoft.Data.Mashup.ValueError.Key","detail":{"type":1,"value":"[Schema = \"dbo\", Item = \"vTREXElearninData\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"Name\", \"Data\", \"Schema\", \"Item\", \"Kind\"}, {})"}}],"exceptionCulprit":1}}} Table: vTREXElearninData.

    My suggestion is to open the pbix file in Power BI Desktop, then go to Power Query to open the Advanced Editor, then find the table related to the above message, check which column names in the table have been adjusted, and put the adjusted names Replace the old names.

     

     


    Regards,

    OliT

OliT's avatar
OliT
Resolver I
4 years ago

Hi Rajesh4655TREX 

>> {"code":"Microsoft.Data.Mashup.ValueError.Key","detail":{"type":1,"value":"[Schema = \"dbo\", Item = \"vTREXElearninData\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"Name\", \"Data\", \"Schema\", \"Item\", \"Kind\"}, {})"}}],"exceptionCulprit":1}}} Table: vTREXElearninData.

My suggestion is to open the pbix file in Power BI Desktop, then go to Power Query to open the Advanced Editor, then find the table related to the above message, check which column names in the table have been adjusted, and put the adjusted names Replace the old names.

 

 


Regards,

OliT