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
mpwilliamson

Power BI Service Failing to refresh SharePoint lists - Fine in Desktop -

Submitted on ‎08-14-2023 04:47 AM Submitted by Advocate II on ‎08-14-2023 04:47 AM
https://community.fabric.microsoft.com/t5/Service/Power-BI-Service-Dataset-Refresh-Error-Expression-Error-The/m-p/3378733   There is already an ongoing thread in the Community PBI Service forum but I thought it could do with being here too for visibility.   Symptoms:  SharePoint Online lists meeting certain criteria fail to refresh with error Expression.Error: The column '<ccon>ID' of the table wasn't found.. ID. </ccon>. The exception was raised by the IDbCommand interface. Table: [Table Name]   Refresh in Power BI service was working fine for these reports across multiple tenants until reports running from 9/8/2023 midnight UTC onwards.   Some possible trigger conditions noted in above thread:   V2 connector and empty SharePoint list created before a certain date on SharePoint Teamsite (classic w/o Team)  V2 connector and ID column for the list isn't being imported to the data model (i.e. query filters it out)   I found in the second circumstance as long as the list has data in it you can get it to refresh by including the ID column in Power Query instead of removing it, but empty lists just fail completely.   @sulleyinoz mentioned there is a ticket open with MS about their issues with blank lists, is there any acknowledgement this is a wider issue and is being worked on?   Thanks   Mark   ... View more
Status: Accepted

Update：

 

The issue is already fixed in all regions and clusters. A fix on this issue will be available around the mid-September release.

As a workaround for Power BI Dekstop for now, Customers can add the ID column back to the select statement within the M Query if customers are using ID column in "Table.SelectColumns" - Customers can remove the ID column within the M Query if customers are using ID column in "Table.RemoveColumns" 

 

Best regards.
Community Support Team_Caitlyn

 

See more ideas labeled with:
24 Comments (24 New)

Apply button is greyed out when adding a data source to the on-premise data gateway

Submitted on ‎01-12-2023 10:32 PM Submitted by Anonymous on ‎01-12-2023 10:32 PM
I noticed when I published a report with an on-premise data source (SAP BW) along with cloud data sources (Sharepoint), the Apply button is greyed out in the gateway connection settings:   Again, this is only applicable to newly published datasets. For the existing ones, there are no errors, and I can refresh successfully. Like this one, it has actually the same setup, just published in a different workspace some time ago: I just experienced this yesterday.  Any of you are experiencing it now? Appreciate the responses! EDITED--   Check out the comments for the workaround   Microsoft has also posted the issue on the Power BI Support page. Expect the fix to be on 24th of January   ... View more
Status: Accepted

Hi @Anonymous ,

 

This is acknowledged as an issue. We have reported the issue and submitted it to the internal icm platform, No:360537118 . Engineers will do their best to resolve the issue. I will update you here if there is any progress , please be patient.

 

 

Best regards.
Community Support Team_ Caitlyn

 

See more ideas labeled with:
21 Comments (21 New)
ujjwal62000

Suddenly Border displayed on the slicer in the workspace

Submitted on ‎12-14-2022 10:23 PM Submitted by Advocate I on ‎12-14-2022 10:23 PM
  Hey Team, I am sharing you the Screen shot how slicers looks like before and after ,we are facing the issue in all our dashboard in the workspace please help .       ... View more
Status: Accepted

Hi all,

 

A new production Issue is added in Power BI Known Issue list.

Engineers are working on the fix, ETA will be updated once available.

 

Best regards.
Community Support Team_ Caitlyn

See more ideas labeled with:
21 Comments (21 New)
AntonioVieira

New Button slicer visual bug

Submitted on ‎02-22-2024 09:27 AM Submitted by on ‎02-22-2024 09:27 AM
After updating my power bi, my new button slicer is having visual problems. I dont know if its a bug in the new update or i do something in options. When a select one category button others categories button gets weird. this is after i update my power bi desktop this is how buttons looks before update sorry for my bad english, can anyone help me? ... View more
Status: Accepted

Hi  @AntonioVieira 

I tested with 2.126.927.0 64-bit (February 2024) and 2.124.2028.0 64-bit (December 2023) , it is normally in December version . I have submitted this issue to ICM , I will come back with updates if there is any progress .

vyetao1msft_0-1709025525498.png

 

Best Regards,
Community Support Team _ Ailsa Tao

 

See more ideas labeled with:
5 Comments (5 New)
hamzashafiq

Stuck at Creating Connection Model

Submitted on ‎09-27-2021 02:31 AM Submitted by Kudo Collector on ‎09-27-2021 02:31 AM
I am stuck at this point when I click on the Refresh button. Looks like there is a problem in September 2021 update, I've downgraded to August and it's working fine.   ... View more
Status: Accepted
See more ideas labeled with:
69 Comments (69 New)
PVO3

Power BI Desktop freezes 10 times a day

Submitted on ‎12-28-2021 05:50 AM Submitted by Impactful Individual on ‎12-28-2021 05:50 AM
Hi all,   I'll try to explain the issue I'm having.  Power BI runs fine, until a random moment. Perhapse I change something in a visual or a measure, but then all my visuals start to refresh and in 90% of the time they don't recover at all and Power BI simply freezes. Sometimes I even have to do a hard reboot. The changes I'm making are very small.   I sometimes I have the idea it has something to do with IntelliSense and/or Microsoft Edge Webview2. Yesterday I was typing a DAX syntax and by pressing tab, it took the suggested function. Every single time I did this, Power BI desktop frooze. Also, sometimes it generates multiple Webview2 processen (screenshot).    It's pretty much impossible to work at the moment. Using the most recent PBI December 2021 desktop update. Is there a fix for this? ... View more
Status: Accepted

Hi All,

According to my research, a similar issue has been reported internally, so stay tuned. ICM: 279388210

 

In the latest update of this ICM, the engineers have found the issue is related to the WebView2 browser crashing and are working to find the root cause of this issue.

 

I will update here once I get any information.

 

But if you want to get a solution for this kind of desktop problem based on your specific situation as soon as possible, I suggest you to open a support ticket to get the direct help from the technical support team of Microsoft.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

See more ideas labeled with:
122 Comments (122 New)
GregMarbais

Data Load Failures and Reports Spinning

Submitted on ‎02-23-2022 06:36 AM Submitted by Advocate V on ‎02-23-2022 06:36 AM
Ever since about 6am Eastern today, my dataset refreshes have been failing and the reports are just spinning - no errors, just spinning like it's trying to load the data. ... View more
Status: Accepted

Hi,

There is a Service Outage/Degradation mentioned on the support page of the Power BI, so stay tuned:

vrobertqmsft_0-1645668599972.png

 

https://powerbi.microsoft.com/en-us/support/

 

I will update here once I get any information.

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

See more ideas labeled with:
67 Comments (67 New)
khxlvin

Cannot set fixed number of rows for Slicer (New) visual - February 2024 Update

Submitted on ‎02-18-2024 10:41 AM Submitted by on ‎02-18-2024 10:41 AM
The functionality of the new slicer visual appears to be malfunctioning in the latest February 2024 update. The ability to set a fixed number of rows for display has been replaced with a maximum row setting which is not what we expect. The slicer will justify to the bottom if the number of rows is less than the maximum set in Format. This does not align to our current report specifications unfortunately. Is it possible to bring back the option to set a fixed number of rows instead of the maximum? ... View more
Status: Accepted

Hi @khxlvin ,

 

We have reported this issue and submitted it to the product team.
They have been aware of the issue and the engineers will do their best to resolve it. I will update here if there is any progress, so please be patient. 

 

Best regards.
Community Support Team_ Caitlyn

See more ideas labeled with:
4 Comments (4 New)
lucilehan

Power BI Server Issue - Subscription and Report Performance

Submitted on ‎03-13-2024 09:59 AM Submitted by on ‎03-13-2024 09:59 AM
Is there a known issue on the Power BI server today?   We have a rucurring report subscription scheduled to be sent out 9:AM EST every day. There hadn't been any changes to the semantic model / subscription settings, but there was a significant delay today (3hrs) and wanted to to know if this is a known issue.   Also got some end-user feedback that they are noticing slower performance. ... View more
Status: Accepted

Hi @lucilehan ,

 

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.

 

Best regards.
Community Support Team_Caitlyn

See more ideas labeled with:
2 Comments (2 New)
Ian_Altis

Power BI Template not saving all properties

Submitted on ‎06-15-2023 07:24 AM Submitted by Advocate III on ‎06-15-2023 07:24 AM
I have noticed today (June 2023 version) that some measures, relationships and sort by columns are not being saved to the PBIT file.  I have tried several times and ased a colleague to do the same and we get the same results. ... View more
Status: Accepted

Hi @all,

 

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.

 

This issue has been addressed and will be available in the next release of Desktop. No clearly ETA for now.

I will update here if there is any progress, so please be patient.

 

Best regards.
Community Support Team_Caitlyn

See more ideas labeled with:
25 Comments (25 New)
ashleyfiore

Visual layering and sizing seems to be skewed

Submitted on ‎03-10-2023 06:37 AM Submitted by Advocate III on ‎03-10-2023 06:37 AM
Visuals are not maintaining layering orders and text is not maintaining sizing. ... View more
Status: Accepted

Hi @all,

 

We have reported this issue and submitted it to the product team.
They have been aware of the issue and the engineers will do their best to resolve it. I will update here if there is any progress, so please be patient. 

 

Update:

This issue will be fixed in a future release of Power BI . There is no clear ETA at this time. Sorry for the inconvenience.

 

Best regards.
Community Support Team_ Caitlyn

 

 

See more ideas labeled with:
25 Comments (25 New)
chang_B

Calculated column works in Power BI desktop but not Power BI service. Visual won't load.

Submitted on ‎02-15-2023 05:46 AM Submitted by Advocate I on ‎02-15-2023 05:46 AM
I have a pie chart visual in my report that uses a calculated column as one of the fields. Up until now it stopped working in Power BI service. Nothing has changed on the report and it has always worked in the past. The visual works fine in Power BI desktop but when published to Service it gives me an error. Any ideas why it would stop working suddenly?     ... View more
Status: Accepted

Hi @chang_B 

It’s a known issue . The engineers are actively working on this issue and I will come back with an update if there is any progress.

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
46 Comments (46 New)
mark-alford

BUG: We couldn't get your datamart's updated schema

Submitted on ‎05-22-2023 03:19 PM Submitted by on ‎05-22-2023 03:19 PM
Unable to refresh data in the datamart, following error.   We couldn't get your datamart's updated schema The datamart data is invalid Activity ID: f817febf-3293-4b66-a64d-0ac1c9987419 Request ID: b247eba4-d0b6-440d-8000-e8d6fe3d6459 Correlation ID: 0fefd113-83ba-4f76-c8d0-6d4464a511b2 Status code: 400 Time: Mon May 22 2023 23:16:52 GMT+0100 (British Summer Time) Service version: 13.0.20726.71 Client version: 2305.3.13975-train Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/ ... View more
Status: Accepted

Hi @mark-alford 

It’s a known issue . The engineers are actively working on this issue and I will come back with an update if there is any progress. 

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
36 Comments (36 New)
Adescrit

Repeated Prompts to Sign In

Submitted on ‎07-04-2023 02:32 AM Submitted by Impactful Individual on ‎07-04-2023 02:32 AM
For the last two days, I'm repeatedly presented with the following message in Power BI desktop asking me to sign in, even though I am already signed in. I am signed in to Power BI desktop to a "Work or School account" that is different to own my organisational account. As I'm a consultant I often work in multiple accounts per day and am rarely logged into my own organisational account.   If I click on "Work or school account" (the bottom option), and then sign into an account, I will be signed into Power BI Desktop but the message prompting me to sign in will re-appear. If I click on the "X" to close the message, it will re-appear. If I do this 7 or 8 times the message prompting me to sign in will finally disappear. However when I move to a new Power BI Desktop window (a different pbix file) the issue will repeat. I'm prompted to sign in, even though I already am signed in, and I need to click on the "X" 7 or 8 times.   My colleagues have reported experiencing a similar issue / bug.   ... View more
Status: Accepted

Hi  all,

 

There has been internal feedback from engineers about this issue and it will be fixed in a future release, no definite ETA at this time.

 

Best regards.
Community Support Team_Caitlyn

See more ideas labeled with:
16 Comments (16 New)
aglpr

Google Analytics Connectior Beta (2.0) - "description" record not found

Submitted on ‎07-03-2023 08:09 PM Submitted by Advocate II on ‎07-03-2023 08:09 PM
Hello,   Thank you for providing the GA4 connector for the Power BI Desktop.   I encountered an issue when I tried to connect the GA4 account to our dataset, I encountered the error as mentioned above.     Anyone knew what is the issue? I tried to navigate to other GA4 property/GA4 account and it's working fine   Thank you! ... View more
Status: Accepted

Hi  @aglpr 

It’s a known issue . The engineers are actively working on this issue and I will come back with an update if there is any progress.

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
29 Comments (29 New)
cassidy

Bug: Excel Power BI Datasets is showing Blank pane to Users

Submitted on ‎04-27-2023 11:35 AM Submitted by Power Participant on ‎04-27-2023 11:35 AM
Starting around 4/21, users across multiple tenants started see a blank white pane when trying to choose a Power BI Dataset in Excel.   ... View more
Status: Accepted

Hi @cassidy ,

 

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.

 

Best regards.
Community Support Team_Caitlyn

 

See more ideas labeled with:
32 Comments (32 New)
PaulDBrown

Pinning visuals to dashboards bug

Submitted on ‎11-02-2022 10:12 AM Submitted by Community Champion on ‎11-02-2022 10:12 AM
There appears to be a bug when pinning visuals to dashboards. It  seems to work for table/matrix visuals, but no for any other type  (the visuals in the gif are standard PBI visuals)   ... View more
Status: Accepted

Hi all,

 

We found similar cases reported by other colleagues internally. They have reported the issue and submitted it to the internal icm platform, No: 346379883.

Engineers will do their best to resolve the issue. I will update you here if there is any progress , please be patient.

 

Tested workaround : In Power BI Service edit mode untoggle title and retoggle title and save the report then we can pin the tile to dashboard.

 

Best regards.
Community Support Team_ Caitlyn

See more ideas labeled with:
16 Comments (16 New)
shabeer

Dataset refresh error on Service

Submitted on ‎07-06-2023 01:16 AM Submitted by on ‎07-06-2023 01:16 AM
Hello Team,   My Power Bi dataset is not getting refreshed from yesterday. I have found out the issue is with Dataset that contains the Power Bi Dataflow (Legacy) connection sources.   It is throwing the error as "Access token has expired, resubmit with a new access token.". However, there is no issue when we go ahead with Power Bi desktop refresh.   The issue is not only with one dataset. The issue reasons are changing time to time. The same datasets were OKAY till yesterday evening GST.   Attaching the error messages for your reference.           Best Rag, Shabeer M P ... View more
Status: Accepted

Hi @shabeer 

It’s a known issue . The engineers are actively working on this issue and I will come back with an update if there is any progress.

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
26 Comments (26 New)
homanz

Formula bar not showing for report level measures using live connection after Nov 2023 update

Submitted on ‎11-20-2023 07:53 PM Submitted by on ‎11-20-2023 07:53 PM
Hi there, After Noveber 2023 update, the formular bar is not showing when we are trying to create a report level measure using live SSAS connection.     Could you please fix it ASAP   Thanks!   ... View more
Status: Accepted

Hi  @homanz 

The issue has been reported to ICM and the PG team is verifying the issue, the October version is now displaying the Formula bar properly. It is recommended to use the October version for the time being, and upgrade to the November version after it fixes this issue.

 

Best Regards,
Community Support Team _ Ailsa Tao

See more ideas labeled with:
2 Comments (2 New)
JustSayJoe

New Card visual's reference label spacing not maintained on service

Submitted on ‎12-04-2023 02:06 PM Submitted by Advocate II on ‎12-04-2023 02:06 PM
I've noticed that when I publish my report to the online service, the New Card reference label spacing settings that I set on PBi Desktop are not maintained when I view the report on the service, and some data is cutoff. This is becoming annoying. Is this a known bug or am I doing something to cause this perhaps? ... View more
Status: Accepted

Hi all,

 

This will be fixed in the near future, please retry it later

 

Best regards,
Community Support Team_ Scott Chang

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

Helpful resources