Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Power BI setup: querie...
Finance | Project Operations, Human Resources, ...
Unanswered

Power BI setup: queries don't work

(0) ShareShare
ReportReport
Posted on by AhmedFad 37

Hello guys,

I'm trying to setup Power BI on SAT environment.

1. I did create an App Registration in azure and assigned the permissions.

2. PowerBi.com configuration done in Dynamics

3. faced a problem in deploying the files, but signed up in app.powerbi.com and was able to deploy.

4. after deploying, all the queries don't work (like the tables are not there)

Kindly assist.

Thanks in advance.

  • Suggested answer
    Navneeth Nagrajan Profile Picture
    Navneeth Nagrajan 1,794 Super User 2025 Season 1 on at
    Power BI setup: queries don't work
    Hi AhmedFad,
     
    All your pre-requisite steps are fine but there are a few steps that were missed in the data push to get the reports refreshed.
    1. Ensure that this batch called Deploy Measures has been executed successfully.
     
     
    2. Also, ensure that the entity store setup under System Administration -> Setup -> Entity store has been set to run at least once in a day. If step number 1 is completed successfully, step number 2 will work successfully too.
     
    The reports should show up the right set of data. 
  • AhmedFad Profile Picture
    AhmedFad 37 on at
    Power BI setup: queries don't work
    In my case it was the batch job failing.
     
    go to Batch Jobs > search for Full Reset > then try to force it to run again.
    * schedule it after 5 minutes or more.
    * change the status so that it runs again.
     
     
    also, sometimes I needed to enable all entity stores (refresh all) even if not related to the dataset you are targeting directly.
     
    let me know if it works.
  • Community member Profile Picture
    Community member 2 on at
    Power BI setup: queries don't work
    Hi
     have the same, any solution?
     
  • AhmedFad Profile Picture
    AhmedFad 37 on at
    RE: Power BI setup: queries don't work

    anybody can help?

  • AhmedFad Profile Picture
    AhmedFad 37 on at
    RE: Power BI setup: queries don't work

    this is another type of error:

    Couldn't load the data for this visual

Invalid object name 'dbo.LedgerCovLiquidityMeasurement_LedgerCovForecastActual'.. The exception was raised by the IDbCommand interface.

Please try again later or contact support. If you contact support, please provide these details.

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans