Power BI-Support
Suche
Re: FILTER on multiple tables
The CALCUATE function is pretty handy and you can do some pretty powerful stuff with it if you need to.
Re: Help creating a table based on another one (only distinct value)
I know it, but way too often the tables are not optimized for Business Intelligence operations
Re: count customers only in one category and not in other
thanks @Zubair_Muhammad!!
count rows vs has one value
Is there an update to this? https://powerpivotpro.com/2011/03/the-magic-of-ifvalues/ =IF(COUNTROWS(VALUES( ))=1, &n...
Re: Automatically refresh JSON feed
Hi Angelia Thanks - I'll look into options outlined! I'm thinking the other way to incorporate the webhose.io JSON feed into Power BI is via Power BI's REST APIs? Tha...
Re: Does Power BI mobile app support preauthentication of Azure Active Directory?
Hi, Thank you for your suggestion. I will try contact to mobile team.
Re: Unable publish from Desktop to Service
Hi @mariusbr, The fix for this is a fix in the service code. That fix should be in MSIT early next week and then in PROD a week later. Best Regards, Qiuyun Yu
Re: Advance Editor dateadd function issue
Hi @kumarleau, It seems to be that you may mix DAX and Power Query(M). DATEADD function is a DAX function, so it cannot be used in Query Editor. You should use it under Modeling tab l...
Re: Displaying county shapes in Power BI
Hi @DQuigg, Have you try to use filled map visual? It support analysis shape based on latitude and longitude. Reference: Filled maps (choropleths) in Power BI (Tutorial) Map visualiz...
Refer to a parameter for Comma-Separated Values data source
Hi Everyone, I cannot find a way to refer a parameter to the file path parts. Is there any way to do this? Or Power BI Desktop Developer has oversight of this.
Re: Güncellemede Ağ Geçidi Bağlantı Hatası
Hi @ssonmez, If the Google translate works fine, the issue should be that one dataset refresh is failed with this error "The gateway operation was explicitly canceled by the user or b...
Re: comma seperated is not reflecting
Hi Sir, I am not a PRO user I am unable to see the create support ticket option . I followed as u shown but....
Re: measure for all records available in the table as drilled
@lephilby, Add another filter ALL ( Workload[Team Leader] ) to CALCULATE Function as well.
Re: Invoke Function Based on User Selection
Hi @a68tbird, No. It is not possible to pass a slicer selection to Power Query and invoke the custom function. Please be aware that Power BI always gets dataset first via Power Query,...
Design pie chart in power bi
I am new to power BI . I need to design chart in power like this . Please provide the way step by step .
Scrolling Capability for Filters Tab Missing on Web Interface of Power BI Report Server
In the web version of the Power BI Report Server (on-premise) solution, the filter tab does not allow for scrolling. When there are more than a few filters added or when the filters are expanded on a...
Re: don't have any gateway installed or configured
Hello @v-ljerr-msft For the MSSQL I have on-premisse gw, but I do not want to refresh Excel data at PB service. Exist a way how to disable it?
Re: Two tables with repeated filters
@awu3639 It compares the values in two columns and gives you only matching result. If one column has OatMealPie and other column has Oat Meal Pie it doesn't match.
Re: Moving/Copying PowerBI Reports/Dashboards from "My Workspace" to a group
Just a heads up I found in another article specific to publishing apps. Note: Content that originated from copying an organizational content pack cannot be published as part of an app. ...
Re: Security for SSAS live connection not working
Hi, we face the same problem now. I 've downloaded the CU but it didn't help. If someone solved this problem by CU download https://support.microsoft.com/en-us/help/4018908 ? Thank you for your help,...
Re: Calculate filtered by specific Date using selectedvalue
This is my problem, when I use seletevalue in order to filter my measure st_total based on date filtered on dcalendario.
Re: Monthly Averages
If you are using a calendar table try using this: Monthly average _ = DIVIDE ( CALCULATE ( SUM ( In_Out[Total In] ), DATESBETWEEN ( 'calendar'[Date], ...
Content Packs vs Apps
Hello together, So as I was doing some research about implementing Power BI in our company and embed it on Dynamics 365, I have come across one solution - that actually should be replac...
Export Data - Data Exceeds the Limit
Hi, I suspect this comes with the November update. When I try to do an Export Data from a Matrix or Table I am now getting a Data Exceeds the Limit error, I used to be able to Export data wi...