DEV Community

Dan Benitah
Dan Benitah

Posted on • Edited on

Fixing Power BI report's credentials details error in Microsoft Fabric

After publishing the Power BI report from the QueenOfTheSky demo, I encountered an issue in Fabric. Despite being directed to my Power BI workspace homepage, it wasn't clear how to proceed next.

Issue Summary

Following the steps in the build Power BI report section, I encountered an error post-publishing. The Power BI desktop app was used to open and fill in the report (.pibt), which was then published. However, upon accessing the report, an error banner indicated a connection issue and provided a link to edit settings. This link redirected me to the Power BI homepage without clear instructions on updating the connection settings.

The solution involves three seperate methods to update the connection settings for the report, identified as QueensOfTheSky_rpt:

  1. via the setting menu
  2. through workspace's lineage view
  3. semantic model using the workspace list view
  4. accessing the semantic model settings directly from the report

All methods are detailed below, with steps to guide you through updating your credentials.

How to Update Your Credentials

Update your credentials using the settings menu

From anywhere, select the Settings Menu > Power BI Settings > Semantic model tab > Select your report (QueensOfTheSky_rpt in our case) > Datasource credentials

Through the settings menu

Update your credentials using the workspace's lineage view

On your workspace page, select the ellipsis on your report's semantic model card and go to settings. You can now update your datasource credentials.

Through the lineage view

Using the list view

In your workspace, look for your semantic model (I filtered by "rpt"). Click the ellipsis and select settings.

Through the list view

Semantic model settings from the report

While on your report:

(1) Select the 3 dots > view Semantic model
Through the report

(2) File > Settings
File settings on the semantic model

That's it for now

Additional guidance might be provided as Microsoft continues to refine and address these navigational challenges.

This guide aims to help you navigate and resolve connectivity issues in Power BI, ensuring a smoother experience with the QueenOfTheSky demo.

And a big THANK YOU to the contributors who created that cool demo!

EDIT late Feb : added 4th method

Top comments (0)