If you got a text field with carriage returns when donwloading a csv from a table visualization, PowerBI creates an additional row per carriage return. The option in query editor replacing values - special characters - carriage return doesnt remove the carriage returns values from the field. This should be fixed. If PowerBI works with carriage return in texts you shoud be able to remove it, if it doesnt, it shouldnt exist in the csv downloaded. ... View more

I have a Live-Conneciton to a SSAS Multidimensional Database (Developing Scenario – for production we go over the Power BI Enterprise Gateway - there we have the same behavior). When I’m creating a report/dashboard anything works fine. But when I try to create a Matrix or a Table in which several Dimensions (some of them are kind of hug dimensions) are involved, I run in a performance problem. The SSAS Server runs out of Memory (32 GB RAM). The Cube is not so big – so I think the 32 GB of RAM should be enough. On a blog I found an interesting article where the same problem is described: https://blog.crossjoin.co.uk/2016/09/26/ssas-multidimensional-caching-related-performance-problems-with-power-bi-tables/ At the moment I implemented the workaround to disable the total row and then anything works fine. But that’s not really satisfying for doing nice reports. ... View more

I am getting this error since morning , could you please let me know the cause of this error or it is a bug? ... View more

I am confused about refreshing web data sources. I used to be able to set up a refresh schedule without a personal gateway. Now when I publish something to the Power BI service, it treats the web data source as an on prem data source. https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-desktop-file-onedrive/ The above address says that a web data source is an on prem data source. The below address says, "A personal gateway is not required in order to refresh datasets that get data only from an online data source." https://powerbi.microsoft.com/en-us/documentation/powerbi-personal-gateway/ So which is "Web"? An online source or an on prem source? Thanks for your help. ... View more

NULL ... View more

Hi Using the Quickbooks online get data source is failing as of recently, once selecting Quickbooks online the message "Please hold on while we load a few things..." keeps spinning for ever with nothing happening. The desktop connection works, and the a while ago the cloud connection was working. Please advise. ... View more

Can you help me sign in quickly since I have a presentation soon. ... View more

When importing a sql server table with datetime columns the cpu and memory usage spikes. This causes power bi and Windows in general to become unresponsive. The more datetime columns in the table the higher the memory spikes and the cpu is maxed for a greater length of time. For example, my data set has a table with 26 datetime columns, in addition to other column types, and power bi desktop returns an out of memory error when importing this table. If the query is limited to exclude the datetime columns then the table is imported quickly with little additional cpu and memory usage. As the datetime columns are included back into the query, cpu usage and memory usage increase at a near linear rate until the out of memory error occurs. This happens at approx. 20 datetime type columns. ... View more

As of today, all our excel files are not rendering in the service. I see Excel Online: We're sorry. We ran into a problem completing your request. Please try that again in a few minutes. It's not going away. ... View more

I tried a lot of times for importing multiple files from sever but its shows error that: XML for Analysis protocol error: The server response format is unexpected. All tags between an Exception element and the Messages section must be closed. ... View more

I created a pbix with import from Onedrive as described in https://powerbi.microsoft.com/de-de/documentation/powerbi-desktop-use-onedrive-business-links/ In the past it was possible to schedule updates in Power BI Web using Oauth2 as authentification. In the last 7 days it seems there was a change in Power BI Web - although authentification works in the first place in the UI, service says credentials are wrong. ... View more

I am using Cisco VPN Any Connect to VPN into another customer domain. I can ping the SQL SErver and connect to it via remote desktop using my alternate domain credentials, but when I try to log into the server from power BI using my alternate credentials, i get a 'user not authorized' error. ... View more

Providing Sharepoint URL for Connection seems impossible (at least in German language version) https://snag.gy/YV5y4f.jpg ... View more

When scheduling or updating a dataset, it either takes a lot of time or fails. I've reinstalled gatewey, I updated the relay in the latest version of power bi desktop and I'm still unsuccessful, anyone know how to tell me about the minimum connection speed to upgrade Power BI? I believe it has to do with the speed of the internet connection! ... View more

I am unable to load a content pack for Planview Enterprise using the proper credentials. I've verified with Planview Support that I'm using the correct steps, but it's still not working, and they've advised me to open a ticket with Microsoft for assistance. Please advise. Thank You. Andy Johnson ... View more

I have added an Oracle Database table in power bi via Direct Query and I cannot see all of the records in the table. E.g. the Table has 6 records and I can only see 2-3 of the records in Power BI ... View more

In desktop, I have a dataset with 153 reports, and the report pane just turned black and my tabs disappeared, although the number is still listed. ... View more

Something must have changed from Power BI in the last couple of days. I've created a report using Power BI Desktop that allowed me to upload data from an excel spreedsheet table that was stored in Sharepoint. The data in excel is manually added and does not synchronize with anything. When I published the report 3 days ago everything was ok and the credentials were ok to schedule a refresh.... it used to say "Sharepoint" as the credentials needed. Now the same report, without any changes to anything, if it gets published, power bi online is forcing me to add the credentials... but it says "SharepointListOnPremise" this is wrong because I do not require a gateway or anything as such... my permissions did not change recently either, what is happening? ... View more

I accidentally deleted my dataset, and all reports and dashboards ONLINE were deleted. I would like to restore the previous dataset, hence my reports and dashboards. ... View more