Plaza 365
Plaza 365

No results found for your search

RegisterLog in

8

Create PivotTable unsuccessful – Power BI and Excel

Visit article

#bi

#create

#excel

Dynamics 365 Business Central

Category

Oct 12, 2024

Published date

Text

Article Type

AI Summary

  • The author encountered difficulties connecting to a Power BI data model through Excel to create a dashboard.
  • Various troubleshooting steps were taken, including searching Google, checking the event viewer, and fiddling with settings on a new laptop.
  • A custom event viewer view was created to display warning and error events from all event logs in the last hour.
  • Despite efforts to resolve the issue, including logging out of profiles and examining data connections, no solution was found.
  • Chat GPT was used successfully to update the identity provider URL in the connection string, leading to progress in resolving the error messages.
  • Changing the dataset name, making it premium by user, and connecting to a different dataset did not resolve the issue.
  • Chat GPT provided the solution to find the appropriate dataset_id value and include it in the connection string, ultimately resolving the problem.
  • The author plans to write a post about cube functions in a future article.

Registered users can view the full text for FREE!

Sign In Now!

Cookies Consent

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies.