Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / No report data table w...
Finance | Project Operations, Human Resources, ...
Unanswered

No report data table with name <TableName> Exists in repot schema for data provider

(0) ShareShare
ReportReport
Posted on by Muhammad Saleh 15

I have 14 Datasets pointing to a single DP class with one SSRS Report attached to it, every time I try to execute after entering parameters, the error shown above is thrown on F&P dashboard

I have tried:

  1. Restarted IIS
  2. Restarted SSRS
  3. Model build and database sync
  4. Deleted All datasets and recreated them (from SQL server too)
  5. Recreated Contract, UI and DP class from scratch (IN SEQUENCE, tables first -> classes -> report -> menu)
  6. Cleared Cache

My Conclusion:

Report throws this error after adding more than three datasets, works just fine with three datasets, 

NEED A WORKING SOLUTION

  • Community member Profile Picture
    Community member 2 on at
    No report data table with name Exists in repot schema for data provider
    I'm also encountering the same
  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,110 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider

    Hi,

    Anything, i did new not duplicate , because on duplicating already waste 1 day then on another day i recreate class and table object now resolve.

    Best Regards,

    Shabir Ahmad

  • atajjo Profile Picture
    atajjo 509 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider
    [quote user="Shabir Ahmad"]

    Hi ,

    My issue was resolved by writing again DP class Code and recreating  tmptables .

    Best Regards,

    Shabir Ahmad

    [/quote]

    Congrats then. Just curious, did you duplicate these object or create them manually again from scratch? Because I tried duplicating the tmp table and it didn't solve the issue.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,110 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider

    Hi ,

    My issue was resolved by writing again DP class Code and recreating  tmptables .

    Best Regards,

    Shabir Ahmad

  • atajjo Profile Picture
    atajjo 509 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider
    [quote user="Shabir Ahmad"]

    Cloud Dev

    [/quote]

    If you're sure there are no issues in your code, maybe you should raise a support ticket with Microsoft? Since you're developing on a cloud machine, it should belong to an LCS project and therefore you should be able to raise issues in that enviornemnt.

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,110 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider

    Cloud Dev

  • atajjo Profile Picture
    atajjo 509 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider
    [quote user="Shabir Ahmad"]

    Hi,

    My environment is D365 fin and ops

    [/quote]

    What tier? (Local VM, cloud dev, UAT, Production)

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,110 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider

    Hi,

    My environment is D365 fin and ops

  • atajjo Profile Picture
    atajjo 509 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider
    [quote user="Shabir Ahmad"]

    Hi,

    My report will must be developed follow the DP calss and etc so i again started creating new tables, and classes etc.

    [/quote]

    Well, my reply was a workaround, not a solution, so of course it's not suitable to every situation. Just curious, in what type of environment do you face this error?

  • Shabir Ahmad Profile Picture
    Shabir Ahmad 3,110 on at
    RE: No report data table with name <TableName> Exists in repot schema for data provider

    Hi,

    My report will must be developed follow the DP calss and etc so i again started creating new tables, and classes etc.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,430 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,043 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans