we have a requirement like connect to JIRA database on a live connection and pre-filter the data before loading to power BI but with live connection the DAX query option is not enabled. Can you please help with this
how to pre-filter data over a live connection in power BI?
814 Views Asked by Sumit At
1
There are 1 best solutions below
Related Questions in POWERBI
- Embedding Microsoft Power BI into Liferay
- PowerBI hierarchy creation without the cloud
- How to create nested tiles in Power View
- BI Designer many to many relationship
- Microsoft Power BI Designer data model to Excel or PowerPivot
- How to link table row content to source in Power View
- Stream Analytic to PowerBI complains about PowerBIOutputAdapterTransientError
- How can I connect datasets from machine learning to SQL database in Azure?
- drilling from powerbi to ssrs
- How do you connect an Azure Table Storage with Power BI through Stream Analytics?
- Power BI Line Chart Getting Confused
- Handle blank value in Complex expression IF condition in PowerBi
- Power BI running total measure not working when no data for dimension
- Periods to Date Calculation MDX
- Loop on M query
Related Questions in DAX
- Power pivot named MDX field
- Error in dax formula
- Find values in two different measures / Measure that summarize transaction values for year-to-date - SQL to DAX
- Filter based on existence in one table and non-existence in another
- Daily average per working day calculation in power pivot
- Power BI Line Chart Getting Confused
- Handle blank value in Complex expression IF condition in PowerBi
- Powerpivot 2016 measure using DAX to sum an array
- Power BI running total measure not working when no data for dimension
- PowerPivot use max date for MTD if no record exists
- Fast reporting with user parameters and temp result sets
- Custom Calendar in Power BI (DAX) - Calculated column for Fiscal Quarter
- powerpivot 2016 - Divide summed value column with grouped raw value
- DAX-Data Model Calculated Measure Blank Result in Excel 2016
- Define the granularity for "day" when calculating NumOfDays?
Related Questions in SSAS
- SSAS Excluding a dimension from aggregation on a measure
- Checking Multiple condition in case statement using MDX query
- Approaching mixed granularity date dimensions for operational periods in cube design
- Jedox How to use it? Main ideas behind data points rules, data flows, ETL... Where to find that?
- What cube deployment changes will force a reprocess?
- How can I find out the datatype of measures in MDX?
- Investigate MDX DistinctCount discrepancy
- How to group record by range and put it on rows
- Errors in the OLAP storage engine: The attribute key cannot be found when processing
- How to install ssas AdventureWorks DW with SQL Server 2008 R2
- SSAS: creating a relation between my dimension table and existing time dimension
- Is connecting to a SSAS cube from SSRS server different than connecting to a SQL DB?
- How to restrict members list in dimension using SSAS perspectives?
- What are the size limits of file *.agg.flex.data?
- Exception occurs while processing SSAS cube
Related Questions in OLAP
- Approaching mixed granularity date dimensions for operational periods in cube design
- MDX union members in different hierarchies
- Jedox How to use it? Main ideas behind data points rules, data flows, ETL... Where to find that?
- Investigate MDX DistinctCount discrepancy
- How to restrict members list in dimension using SSAS perspectives?
- What are the size limits of file *.agg.flex.data?
- Exception occurs while processing SSAS cube
- MDX: Filtering repeated
- Pivot4j/Olap4j adding condition to where clause of generated query
- Star schema role in the Pentaho Mondrian OLAP server
- OLAP cube Member Name instead of ID to filter Pivot
- SSRS mdx report: use dimension on columns
- Intersect Select Query in MDX
- Can a SQL Server OLAP cube be loaded from csv files
- Set of Days in past 6 equivalent MTDs
Related Questions in MICROSOFT-LIVE-CONNECT
- How to define the scope for XBOX while login with xbox in laravel
- How to get the email message from the microsoft live.com
- How do I connect live to SQL Server Analysis Services from Power BI Desktop?
- How to get Microsoft Live profile URL using the ProviderKey value
- Root domain for Microsoft Live application
- Microsoft Live Connect OAuth API stopped returning email in user information
- Live Connect APIs deprecated?
- sign in with windows live connect, similar to Google's "postmessage"
- Windows Live Connect and Open IDC
- Refreshing an OAuth access token for Microsoft Live API
- how to pre-filter data over a live connection in power BI?
- Live Authentication and Permission Scopes
- apis.live.net/v5.0 - How to validate token on server
- OAuth with Microsoft not working correctly
- Microsoft oauth login stopped working all of a sudden?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Live connection is as it says - a live connection. It doesn't support pre-filtering.
If you have access to the database, maybe you can create a view that filters out the data you need and use that as the source in your report? Note that this has an negative impact on live connection performance. Also, you need to be sure that you are allowed to add a custom view to Jira database.