Questions tagged [microsoft-powerbi]

Self service data integration and visualisation service provided by Microsoft. It can integrate data from Excel and other Office programs, and all major databases and analytics tools and web services

Power BI is a suite of business analytics tools from Microsoft to analyze data and share insights. In addition to analysis, it has tools to visualize the data in various forms, like dashboards for monitoring, and interactive visuals in reports.

Product Link: https://powerbi.microsoft.com/en-us/

116 questions
15
votes
2 answers

In Power BI, how do I sort slicer values (other than by name)?

I have a slicer with 4 values {daily, biweekly, monthly, annually}, and I want to sort them in that specific, custom order (that IS NOT alphabetical). My data query has them sorted correctly (by a numbered sort column), and they're sorted correctly…
dav
  • 10,618
6
votes
1 answer

Installation steps of Exact Online driver for Microsoft Power BI

I want to use Microsoft Power BI Desktop edition to run reports including data from Exact Online. The Exact Online driver is not available with the pre-configured sources Microsoft offers. How do I install an Exact Online driver?
4
votes
1 answer

How to remove a data source from Power BI Desktop?

Edit: I found a solution--see my answer below. The answers I've read are old and no longer work (possibly because Microsoft makes substantial changes to the UI on a regular basis). I tried File -> Options and settings -> Data source settings, which…
4
votes
1 answer

In PowerBI, can I use a visualization to display the fields that have been left blank on a given item?

I'm creating a PowerBI presentation that pulls data from a SharePoint list. The list has columns that correspond to questions from a form, and rows that correspond to individual items (i.e., each time someone fills out the form, it creates a new…
user877496
3
votes
1 answer

Does Microsoft Power BI have file size limitations for functionality like Excel Power Query does?

I inherited an Excel data model consisting of multiple workbooks. Each workbook has multiple tabs utilizing Power Queries to get, transform and load data sets from base supporting Excel and csv files. Over time the files of the model have grown…
3
votes
1 answer

Does .pbix file also contain data?

I'd like to send my pbix file to a colleague to make him work on that. Does the pbix file also contain the data or is it just the visualization and they have to load data by themselves?
Phate
  • 241
3
votes
2 answers

How to remove extremely annoying Power Bi popup?

Since an update, I regularly get a really anoying popup in the DAX editor in powerBI whenever I press ctrl-enter. Does anyone know how to turn this 'feature' off? This is the popup: It is particularly annoying considering it can't be closed or…
3
votes
1 answer

Order x axis by month in PowerBi where the months start from 12 - 11

I'm creating a report in Power Bi which I re-fresh each month and display data going back two years on a line graph. Each month the report updates the two year time frame it looks at. For example, Jan 2016 (we call Jan period12) to Dec 2018 (call…
3
votes
1 answer

How to call Power Query M function from external Workbook?

If I have an Excel workbook that is available online and this workbook contains a couple of spreadsheets and some Power Query M functions, is it possible to invoke these functions from another Workbook? I know how to load the workbook with…
KarmaEDV
  • 2,371
3
votes
2 answers

How do you clear pending updates in Power Bi?

I was pulling data from a Sharepoint Server and accidentally chose "Edit" rather than "Load." I didn't actually make any changes. But now Power BI keeps telling me there are pending changes that have no been applied. Every time I try to pull any…
2
votes
2 answers

How can I use Excel to make a chart with two x-axis at different scales?

How can I use Excel to produce charts like the images below? Is it possible? I want to have two different x-axis scales with major tick marks every 10 values. The only data I would want to display would be a single data point, like a dot centered…
Ben
  • 433
2
votes
0 answers

Power BI Report Server Jan 2019 hyperlinks

After upgrading company's Power BI Report Server from Aug 2018 to Jan 2019 version, hyperlinks no longer change color after visited. In previous versions, users would click on a link for the 1st time, and the link would change from blue to purple.…
Ahpitre
  • 21
2
votes
2 answers

Connect MongoDB to Tableau or Microsoft Power BI for real-time analysis

I have a website whose database is MongoDB, I want to track KPIs and analyse them in real-time. I am thinking of Tableau and Microsoft Power BI. But I have not found how to connect MongoDB to them in real-time. Could anyone help?
SoftTimur
  • 1,377
2
votes
1 answer

Stack overflow error importing data to Microsoft Power BI: 'Evaluation resulted in a stack overflow and cannot continue.'

When trying to import data from a database into Power BI (using the Invantive Bridge ADO.net provider) I get an error: Expression.Error: Evaluation resulted in a stack overflow and cannot continue. I like to know why I get this error. Is there a…
Goombah
  • 370
2
votes
1 answer

How to add additional lines across the graph on the Y Axis

PowerBI automatically builds graphs based on my data, but often times it will have few (or ZERO) horizontal lines going accross the Y Axis. It makes it very difficult to see where the data is landing across my graph. I would like to add additional…
Shackrock
  • 830
1
2 3 4 5 6 7 8