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, and I try to get data from that table into my report in Power BI. In the Navigator section I can select the new table, but then on the right side of the window a huge error message shows up that says "DataSource.Error: Microsoft SQL: "Invalid object name...". See the screenshot below.

 

If I want to get data from tables that I created several days ago, no problem, but if I want to get data from any tables that I created today, it just simply not works.

 

My question is that do I need to refresh anything in the background to get it work? Or if not, what could be the reason of the error message?

 

Thanks,

kukszi

 

 

Need Help

4 Replies

  • 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

    • rverner's avatar
      rverner
      Frequent Visitor
      2 years ago

      That worked for me, too. I turned that option on, saved the change, and then turned the option off. 

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    Did anyone ever get a reason as to why this might happen? It happens often to me, and I'd really like to know a solid fix.