Share via

How to fix "Pending queries" in Power BI?

Paula Olim Mendonça 0 Reputation points
2023-09-05T16:20:08.1+00:00

Hi,
Currently I'm doing the PL-300 learning path and in "Use DAX time intelligence functions in Power BI Desktop models" training, I can't do anything because it says that I've pending queries.

So if I try to change a column name or description, won't allow it and keep showing this message if I do "Apply changes".

Help!
issue PBI

SQL Server | Other
0 comments No comments

2 answers

Sort by: Most helpful
  1. Anonymous
    2023-09-06T05:42:46.24+00:00

    Hi @Paula Olim Mendonça

    Power BI has a separate community. You can go there for help.

    https://community.fabric.microsoft.com/t5/Microsoft-Power-BI-Community/ct-p/powerbi

    Best regards,

    Percy Tang


  2. Erland Sommarskog 133.6K Reputation points MVP Volunteer Moderator
    2023-09-05T21:06:09.59+00:00

    You need to do one of:

    1. Install the certificate for SQL Server as in your Trusted Certificates store.
    2. Select the connection option "Trust Server Certificate".

    The latter is less secure, but if this in your home environment, there is not really an issue with it. (If you would be working in a bank or a hospital with some really sensitive data, it would not.)

    Exactly how you set this option in Power BI desktop, I don't know. For help with PowerBI a good place is https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

    0 comments No comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.