Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Share your ideas and vote for future features

Suggest an idea
0 Votes
Vote
NeilHenderson

PowerBI Reports stuck in refresh status

Submitted on ‎05-10-2023 09:46 PM Submitted by on ‎05-10-2023 09:46 PM
Hello,   I have two reports that are stuck refreshing, i have checked the azure synapse sql pool and the queries are no longer running and as its currently refreshing it wont let me refresh again or even stop it. ... View more
Status: Investigating

Hi  @NeilHenderson ,

 

Are you having a problem with reports in import mode not refreshing properly and getting stuck on the refresh page?
Based on the information available we are having a hard time determining where the problem lies and need to investigate further.
As for interrupting the refresh in progress, you can try restarting your On-Premise Gateway.

 

Best regards.
Community Support Team_ Caitlyn

 

 

See more ideas labeled with:
2 Comments (2 New)
0 Votes
Hongju_Jung

A typo in the style option

Submitted on ‎05-10-2023 06:48 PM Submitted by Helper I on ‎05-10-2023 06:48 PM
Hi, Team   Power BI Service version: 13.0.20626.62 Korean PowerPoint: Microsoft® PowerPoint® for Microsoft 365 MSO(version 2304 Build 16.0.16327.20200) 64비트 English PowerPoint: Microsoft® PowerPoint® 2019 MSO (Version 2304 Build 16.0.16327.20200) 32-bit     When I was testing the export of a Power BI report (Embed live data), I noticed a typo in the style options for the storytelling PowerPoint. We're not used to "파선". That should be ‘대시’.   Korean   English   It's already displayed as a "대시" in PowerPoint's native outline feature.   Thanks, Hong ... View more
Status: Delivered

Hi  @Hongju_Jung ,

 

Thank you for your valuable comments. As the problem occurs in other products PowerPoint, please contact the corresponding M365 product support to give feedback on this issue. Sorry for the inconvenience.

 

Best regards.
Community Support Team_ Caitlyn

See more ideas labeled with:
2 Comments (2 New)
0 Votes
Gitu

Can't upload .pbix report to reporting server

Submitted on ‎05-10-2023 01:18 PM Submitted by on ‎05-10-2023 01:18 PM
Hi, When I upload my power bi file to reporting server i am getting this error.only one file I couldn't upload. I have tried with previous solution but no luck.please help me to solve this issue.Thank you ... View more
Status: Delivered

Hi @Gitu ,

 

Usually such problems can be solved by reinstalling Power BI Report Server.
You can refer to the following two threads.

Unable to upload PBIX file to PBI Report server - Microsoft Power BI Community

Solved: Unable to publish report to RS - Microsoft Power BI Community

 

 

Best regards.
Community Support Team_ Caitlyn

See more ideas labeled with:
2 Comments (2 New)
0 Votes
smalltownj0e

HA / Load Balancing and the "Primary" Gateway

Submitted on ‎05-10-2023 01:09 PM Submitted by on ‎05-10-2023 01:09 PM
HI Im setting up my first cluster and it is my intention to utilize load ballancing. Im trying to determine what issues i could face if my gateway marked "primary" goes off line or is removed.    Q1. In this LB scenario what role does the "primary" gateway play in load balancing? Is a primary required in a LB config? I understand its purpose in an HA config but what is its purpose in an LB config? Q2. What happens if the primary gateway goes off line or if i remove it from the list of gateways all togeather when in LB mode? Will one of the other gateways become primary by default? Do i need to designate one of them as the primary manually or build and add a new primary? Is there a requirment to recover the original primary? Q3. If im in load balanced mode and the primary GW goes down will my cluster go into read only mode? i read that in the HA config if you lose the primary it goes into read only mode and want to ensure that is not the same thing that happens in load ballance mode. Thx so much --Joe ... View more
Status: Delivered

Hi @smalltownj0e 

When you create a new gateway and add it to an existing gateway cluster, that one is the main gateway by default.The gateway cloud service always uses the primary gateway in a cluster unless that gateway isn't available. In that case, the service switches to the next available gateway in the cluster.

 

You may also refer to Solved: Re: Identify primary/secondary in on-premises data... - Microsoft Power BI Community

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
2 Comments (2 New)
0 Votes
Vote
trathbone1

Log Analytics App missing from App Store

Submitted on ‎05-10-2023 09:02 AM Submitted by on ‎05-10-2023 09:02 AM
I have noticed the Log Analytics app is no longer available - How can I get it? ... View more
Status: Investigating

Hi @trathbone1 ,

 

I confirmed the issue and it really isn't in the App store anymore.
As far as I know, there is no other way to access it.

If you would like to suggest this feature improvements, you may vote the idea and comment here  to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

 

Best Regards,
Community Support Team _ Caitlyn

 

 

See more ideas labeled with:
1 Comment (1 New)
0 Votes
Vote
bmp_user

BUG: opening file with not active relation

Submitted on ‎05-10-2023 07:29 AM Submitted by on ‎05-10-2023 07:29 AM
I'm trying to open a .pbix file but I get an error like "SecurityFilterBehavior can't be on BothDirections when the relation is not Active" between two columns of two tables.   Then PowerBI returns to the first screen without loading the file.   How can I fix please?  ... View more
Status: Investigating

Hi @bmp_user 

Did you create this pbix file? Does it open on other people's computers with the same prompt?
Maybe you can turn off Automatic relationship updates in options and then open the pbix file again.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships#a...

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
2 Comments (2 New)
0 Votes
Vote

Microsoft Lists - data with text from a drop-down option

Submitted on ‎05-10-2023 07:22 AM Submitted by Anonymous on ‎05-10-2023 07:22 AM
Hello, I am trying to introduce data from my Microsoft Lists but it seems that the algorithm cannot read the data that are in a text format and that they´re coming from the drop-down lists options (comes out as an error).   Is there anyway we can translate this data to numbers so they can be introduced to the tables and charts? Thank you ... View more
Status: Investigating

Hi @Anonymous ,

 

Please correct me if I misunderstood what you meant.
Do you mean that the Microsoft list you import into Power BI should be in text format but show "error"?

Does it work if you uncheck the box and retry it below?

vxiaoyanmsft_0-1683777078931.png

 

Best regards.
Community Support Team_Caitlyn

 

See more ideas labeled with:
3 Comments (3 New)
0 Votes
Vote
romoguy15

SQLDUMPER.EXE BlackWindow

Submitted on ‎05-10-2023 06:24 AM Submitted by Helper IV on ‎05-10-2023 06:24 AM
Hello,   Recently after upating Power BI, I have been getting this black window popup for sqldumper.exe which causes my entire Power BI desktop to crash. Has anyone recently reported this issue? ... View more
Status: Needs Info

Hi @romoguy15 

Can you explain specifically what this black window popup for sqldumper.exe is all about? What version of Desktop have you updated to? Was it normal before the update? If you uninstall the current version and restore to the previous version, can you restore it to normal?

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
1 Comment (1 New)
0 Votes
Vote
MikeGaudet

BUG: The setting dataset screen does not show the list of dataset anymore

Submitted on ‎05-10-2023 05:55 AM Submitted by on ‎05-10-2023 05:55 AM
The setting dataset screen does not show the list of datasets anymore.   It looks like the dataset list box has been reduce to the only show one dataset and you need to scroll the box to see the other datasets.  Not very practical, the prior version way of seeing the list of dataset would be appreciated.     It can still be accessible but in you have to scroll and try to stop to the wanted dataset. Which is not very practical in this context.       ... View more
Status: Investigating

Hi @MikeGaudet ,

 

Can you take a screenshot of your reproduction environment? I am still unable to reproduce the issue.

it is in the top right corner of the "? > About Power BI.

 

Best regards.
Community Support Team_ Caitlyn

See more ideas labeled with:
5 Comments (5 New)
0 Votes
Vote
war4ct

Not possible delete datamart OR update datamart

Submitted on ‎05-10-2023 04:57 AM Submitted by on ‎05-10-2023 04:57 AM
Currently is nott possible update my datamart or even delete it: Activity ID: 6060680a-e1eb-461a-8261-781f0452e273 Request ID: 26b211b3-1cad-498d-919d-213504d596f2 Correlation ID: 0ff2aec0-b7e1-0359-662e-d0590bbb0870 Status code: 500 Time: Wed May 10 2023 08:44:50 GMT-0300 (Horário Padrão de Brasília) Service version: 13.0.20626.62 Client version: 2305.1.13619-train Cluster URI: https://wabi-north-europe-l-primary-redirect.analysis.windows.net/ Datamart error: "Unable to open the datamart because it is not connected to its dataset. Wait a few seconds, and then try again." " ... View more
Status: Needs Info

Hi @war4ct 

What is the corresponding data source for datamart? If you connect directly to the corresponding data source, can you get the latest data? Also does this happen only with specific datamart or all datamart?

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
3 Comments (3 New)
0 Votes
Vote
brendan_w_88

Bug- Successful Refresh but new data is not transformed in Power Query and does not appear in Visual

Submitted on ‎05-10-2023 03:54 AM Submitted by on ‎05-10-2023 03:54 AM
I have an issue on Power BI desktop and Power BI Service, where I have successful refreshes but the data is not reaching the output table in the pipeline. The new data appears on the initial load query from the SQL Server DB. This data then goes through a variety of aggregations, merges and appends. The new data goes partially through this transformation but doesn't reach the final output table.   However in Power BI Desktop if I right click on the output table and click refresh, the output tables will update with the new data.   Can you please advise on any workarounds or similar please? ... View more
Status: Investigating

Hi @brendan_w_88 ,

 

I would like to confirm with you what connection mode you are using?
Are you configuring the correct data source and gateway when refreshing in Power BI Service?

Configure scheduled refresh - Power BI | Microsoft Learn

 

 

Best regards.
Community Support Team_ Caitlyn

See more ideas labeled with:
3 Comments (3 New)
0 Votes
Karen_Mees

Azure maps published report different from desktop version

Submitted on ‎05-10-2023 03:06 AM Submitted by on ‎05-10-2023 03:06 AM
Hi!  I created a dashboard in Power BI that contains an Azure map. To pin specific locations on this map I just used te street, zip code, city, state and country. This works perfectly in the desktop version. However, when I publish the report the pinned locations all change..  Anyone who has an idea how this comes?    Thank you in advance!!    ... View more
Status: Delivered

Hi @Karen_Mees ,

 

“The desktop and the service are 2 different enviroments, the service depends on the browser you are using that's what makes the difference but the data is the same everywhere. ”

 

For original post: Solved: Re: Report published is different from desktop fi... - Microsoft Power BI Community

 

Best regards.
Community Support Team_ Caitlyn

See more ideas labeled with:
1 Comment (1 New)
0 Votes
Vote
davedragn

MDXScript(Model) (156,41) Cannot convert value '' of type text to type number since upgrade

Submitted on ‎05-10-2023 02:48 AM Submitted by on ‎05-10-2023 02:48 AM
I have been working on this file for months and since the upgrade, I have been receiving the above error, any time I try to open a file, edit, create, or delete measures or columns in the data model. I've created 4 new versions, copying and pasting the scripts and visuals. All of the visuals work, there is one measure with an error, that I cannot delete or edit. Upon saving, the same error occurs.   Feedback Type: Frown (Error) Error Message: <ccon>MdxScript(Model) (156, 41) Cannot convert value '' of type Text to type Number. </ccon> Stack Trace: Microsoft.PowerBI.Modeler.ModelingASOperationException at Microsoft.PowerBI.Modeler.ModelManager.<>c__DisplayClass253_0.<SaveChanges>b__0() at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass6_0`1.<RunInActivity>b__0() at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity(ModelingActivityKind activity, Action action) at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity[T](ModelingActivityKind activity, Func`1 action) at Microsoft.PowerBI.Modeler.ModelManager.SaveChangesForCommit(String description, Boolean recalc) at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.Commit(Boolean recalc) at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.Commit(RecalcBehavior recalcBehavior) at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ExtendedModelChangeScope.ExecuteChange(ModelChange modelChange, Boolean isTrustedSource, Boolean saveChange, RecalcBehavior recalcBehavior, String descriptionToTrace) at Microsoft.PowerBI.Modeling.Engine.ModelingEngine.<>c__DisplayClass16_1.<RouteModelChangeAsync>b__3(IExtendedModelChangeScope scope) at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass10_0.<RunExtendedModelChangeAsync>b__0(IExtendedModelChangeScope scope) at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass11_0.<<RunExtendedModelChangeAsync>b__0>d.MoveNext() ... View more
Status: Needs Info

Hi @davedragn 

So did you fix your issue now ?

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
3 Comments (3 New)
0 Votes
Vote
CaseyWen

Can't register BI Pro in China

Submitted on ‎05-10-2023 12:24 AM Submitted by on ‎05-10-2023 12:24 AM
i buy a Power BI pro account. when i register, it shows it is not avaiable in this market. if anyone can help ? Thanks a lot   ... View more
Status: Investigating

Hi @CaseyWen ,

 

You may purchase the license through Microsoft 365 admin center under Billing > Purchase Services. Scroll down to "Other categories that might interest you" and click PowerBI then you will be presented with the license options.

 

I hope it works for you.

 

Best regards.
Community Support Team_ Caitlyn

See more ideas labeled with:
1 Comment (1 New)
0 Votes
Vote
v-xiaoql

CREW-Repeat return update delay

Submitted on ‎05-09-2023 06:07 PM Submitted by Employee on ‎05-09-2023 06:07 PM
Hi,       I found below website update delay in past 2weeks and it should be update data before Tuesday,please help whether it have new rule ,if not please help fix it,thanks. Care - Repeat Return - Power BI ... View more
Status: Investigating

Hi @v-xiaoql 

The latest date is until the 9th of May, do you mean to update to the current latest date ?

vyetao1msft_0-1683787513687.png

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
3 Comments (3 New)
0 Votes
Vote
jchauhan

Schedule refresh is showing error

Submitted on ‎05-09-2023 09:12 AM Submitted by on ‎05-09-2023 09:12 AM
Dear, Below are the steps I have performed. 1. Uploaded 3 csv files in power bi desktop. 2.Created multiple python scripts for these uploaded files in power query editor. 3.Saved the file as "SentimentClassification.pbix" file. 4.Published this to power bi service into work space. 5.Then I opened this pbix file. 6.Clicked on the schedule refresh icon for the dataset.   Getting below error: You can't schedule refresh for this dataset because the following data sources currently don't support refresh: Data source for Query1 Please help me to resolved this issue   Thank you.   ... View more
Status: Investigating

Hi @jchauhan ,

 

Please check that you have configured the correct credentials for each data source.

To validate go to data sets -> click the ellipsis icon -> settings -> data sets.

We need to make sure that the data source credentials are okay.

 

Best regards.
Community Support Team_Caitlyn

See more ideas labeled with:
2 Comments (2 New)
0 Votes
Vote

ERRO: Não é possível exibir este visual.

Submitted on ‎05-09-2023 09:40 AM Submitted by Anonymous on ‎05-09-2023 09:40 AM
Quando publico o relatório, da erro no visual e aparece essa mensagem "Este elemento visual contém um ou mais filtros com colunas excluídas, diferenças de tipo ou outras alterações recentes de modelagem. Tente novamente mais tarde ou entre em contato com o suporte. Se você entrar em contato com o suporte, forneça esses detalhes" porem não realizei alteração.   Relatório publicado      Relatório desktop ... View more
Status: Investigating

Hi @Anonymous 

According to the hint of the error message, the column contained in the visual application's filter may have been deleted, so it caused the error report. So you need to check in the PQ, if any column is deleted.

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
1 Comment (1 New)
0 Votes
Vote
Spudgun79

Is this a bug?

Submitted on ‎05-09-2023 08:31 AM Submitted by on ‎05-09-2023 08:31 AM
in Admin Portal the settings have gone a bit weird. Please see screenshot. Is this normal? All segments of the settings have "Tenantsetting...."    example: Publish "get help" information" is "tenantsetting_tenantsettingpublishgethelpinfo_title"  as I would expect you would need to use when changing from powershell     ... View more
Status: Accepted

Hi @Spudgun79 ,

 

We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

 

Either:
1. Update the Power BI setting to choose a Display Language from the dropdown, and bypassing browser locale
or
2. Updating the Browser locale to English (US)

 

Best regards.
Community Support Team_Caitlyn

 

 

 

Best regards.
Community Support Team_Caitlyn

See more ideas labeled with:
2 Comments (2 New)
0 Votes
vibhormittal

BUG: Dynamic color with measures in not working on visualization using field parameters

Submitted on ‎05-09-2023 07:21 AM Submitted by on ‎05-09-2023 07:21 AM
Hi,  I am using field parameters a lot as it is a great feature. Sadly, the chart color are not dynamic if I use the field parameter as the value.  The red bar chart has the measure as value, and the green bar on left has the field parameter   ... View more
Status: Delivered

Hi @vibhormittal 

I am so glad to hear that your issue has been fixed . I will change the status to "Delivered" .

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
2 Comments (2 New)
0 Votes
Vote

Bug: Refresh cancel failure

Submitted on ‎05-09-2023 06:50 AM Submitted by Anonymous on ‎05-09-2023 06:50 AM
Dataset is in a PPU workspace. Dataset refresh was triggered using an enhanced API call. Simultaneously, a scheduled refresh started. Scheduled refresh completed. But, enhanced-api refresh was stuck. PBI did not allow further api refreshes and refused to let us cancel that refresh. Had to wait til refresh timed-out for api-refresh to function again.   Cancel refresh response: { "error": { "code": "GeneralException", "message": "Cancel enhanced refresh job call to AsWorkloadClient failed. Exception Microsoft.PowerBI.ServiceContracts.PowerBIRemoteServiceException: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: Premium_ASWL_Error" } } ... View more
Status: Investigating

Hi @Anonymous ,

 

I would like to know if there is some detailed error message instead of an error code? Are you having this problem below?

Power BI refreshes are failing with error --Retry attempts for failures while executing the refresh exceeded the retry limit set on the request. 

 

Best regards.
Community Support Team_ Caitlyn

See more ideas labeled with:
2 Comments (2 New)
Idea Statuses

Helpful resources