Power BI - Input box to filter the visuals

Scenario: In this scenario, we will add an Input box in the power bi dashboard that will filter the visuals.

Replace existing data source table with another table in Power bi

Today we will learn on how to replace a data source with another data source in power bi while maintaining all the other relationships and transformations

Steps:

• From home, click Transform data

• Select the Query from the left that you want to replace

• Click Data source settings

• Click Change source

• Select the new source (for e.g.: new excel/csv file)
• Click ok

• Power bi will change the source and refresh all the data.
• You are done.

Power BI - Change your data source credentials (settings)

Scenario: You want to login to a power bi dashboard using someone else's credentials and refresh the data source.

Steps:

• within Power bi Desktop, go to File > Options and settings > Data source settings

• Right click your data source > Edit Permissions

• Go to Database > Supply the new username and password

• Click Save
• Refresh the datasource
• You are done.

Power BI - Could not load file or assembly System.EnterpriseServices

Scenario: when i open a power bi dashboard (.pbix) file, i get an error "Could not load file or assembly 'System.EnterpriseServices', Version=4.0.0.0)

Solution: Start your Power BI Desktop by running it as administrator. Now you will either pass through the error and your dashboard will open or you will see the actual error (most common: database login failure)