Forum Discussion

kukszi's avatar
kukszi
Helper I
3 years ago

Invalid object name - with newly created Dataverse table

Hi All,   This might be a basic question for some more experienced people, but I couldn't find any info anywhere else that would solve my problem.   I have recently created a table in Dataverse, ...
Need Help
SamP_23's avatar
SamP_23
New Member
3 years ago

Hi, 

 

I'm experiencing the same issue. I found a solution that worked for me, hopefully it can help you too. 

 

I went to the affected table in dataverse and edited the 'Doing a mail merge' option to be unchecked and re-saved the table:

I then published the table, and when I checked, the connection to Power BI was working as expected. I tested re-enabling the 'Doing a mail merge' option and re-saving/publishing the table. The connection with Power BI continued to work. I'm no expert in dataverse, but maybe re-saving the table is triggering something behind the scenes. 

 

Hope this helps. 

 

Thanks, 

Sam 

kukszi's avatar
kukszi
Helper I
3 years ago

Hi Sam,

 

Thanks for your answer. Actually, I didn't have to follow your steps because it now works. I waited a couple of days, and now I can get the data from the impacted table into Power BI. I'm sure there was a process that ran in the background, but have no idea what was that. 

 

Anyways, definitely not an ideal solution to wait a couple of days after creating the table, but at least it works. Thanks for your suggestion.

 

Cheers,

kukszi