Explore Power BI on Experts Exchange

Expert Solutions for Your Tech Problems

Power BIPower BI

Power BI is a business analytics tool from Microsoft used for data visualization. It integrates seamlessly with other tools, like Microsoft Excel, ...

Read more
  • 787 Content
  • 263 Contributors

Expert Spotlight
Senior Data Analyst

Veteran in computer systems, malware removal and ransomware topics.  I have been working in the field since 1985.

Troubleshooting Solution

Powerbi and Python

4

Dear experts,


I plan to learn the following two apps/software


1. Powerbi (i think it is query)

2.

Article
Demo

Microsoft Excel & SQL Server:  Self service BI to give users the data they want

12
How to build an Excel spreadsheet that allows users to enter select values via populated combo boxes and hit a magic ‘Go’ button that retrieves only that data from SQL Server based on those selections, using nothing more than standard Microsoft Excel functionality and an ODBC Connection.  
Video
Post

Cool personal story that illustrates the practical benefits …

2
Cool personal story that illustrates the practical benefits of having a peer to peer network as a go…
Advice Solution

Ideas on User Data Input Methods?

byRex
5

My boss has asked me to create a "system" or form for various data owners to use to input requested

Troubleshooting Solution

Excel Zone Expert Discussion, Number 37

bybyundt
185
This thread is for general discussion about all things related to the Excel TA and its experts. Both…
Troubleshooting Solution

How to manage Microsoft Power Platform Database and Log Capacity

3

My client received (2) emails from Microsoft Power Platforms stating that their tenant has used 100

Troubleshooting Solution

PowerBI SSRS Datasource connection issues

1

Hi,

I recently installed PowerBI Reporting Services which went fine. The issue I am having is the

Troubleshooting Solution

Can Power BI create Excel reports?

4

Can Power BI Desktop have the capability of creating mass reports? I have an Access DB which

Troubleshooting Solution

Help with MC707453 error please!

1

A user received this message a day or two ago creating a new folder in one or our SharePoint Online

Troubleshooting Solution

Making backend DB updates from Power BI

2

We're gathering requirements for a front-end to several databases that will combine data in a

Troubleshooting Solution

Assistance with Parameters in Power Query

9
Having problems add parameters to my power qry, I am trying not to think like an excel user and it …
Troubleshooting Solution

How do I change the column color in a Power BI visual?

5

I have a series of four Power BI visuals, per year, over a five year period (20 total). Each year

Troubleshooting Solution

Dynamic SQL in Power BI Report Builder

2

I am facing some difficulties while converting a report built in Crystal Reports to Power BI Report

Troubleshooting Solution

Power BI Matrix Visual - Change background color based on Field Value

1

Hi Experts,

I am a beginner with DAX and Power BI and I have a table and measure as follows:


Event

Troubleshooting Solution

Is it possible to create maps on the census tract level in Power BI?

20

I need help creating maps on the census tract level in Power BI. I've downloaded the shapefiles from

Troubleshooting Solution

Power BI - How to calculate the answers for many questions in the drop down list?

10

Power BI - How to calculate the answers for many questions in the drop down list. For example I have

Advice Solution

What are the best practices and considerations for data source credentials?

byY Y
1

We have created some Excel spreadsheets with queries and Power BI reports, which have been getting

Troubleshooting Solution

Power BI calculated Column using RELATED() Formula

6
Hi Experts,
I have a data set which contains a project code in the format of let's say XYZ and the …
Article

The Power Query Editor

A while back I wrote an article about the Power Query Editor and PowerBI (https://www.experts-exchange.com/articles/37938/PowerBI-and-the-Query-Editor-Save-time.html). I have realized that my coworkers primarily use Excel and So have changed the article to include excel. The result is below and is

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more