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!