I have a requirement like Power BI cloud data should be refreshed as soon as the undlying Azure SQL data is updated. In the cuurent scenario , I have to wait for the schedule refresh to update clould data from undlying Azure SQL data.
Can you please tell me how to automate schedule refresh in Power BI or how to refresh cloud dataset as soon undlying data is updated.
Usually experience this with larger models with 50+ measures. I change the format to thousand seperator and whole number (from general) for a measure and the field pane refreshes with all tables collapsed. Frustrating when you need to format many measures.
Matrix Review - Column Headers : Word Wrap do not work - return to full size when cross-filtered. The option Auto-size columns is turned off.
I have reports with measures of Acumulate and compare with other year. This report was working well until the last Desktop update. The report is working well in the Desktop but when I upload to the website at the first moment it is working well but the result isnt good. This is what I see in the Desktop (the result is correct):
Then I upload to the website, in the first moment is good, but after few minutes that change to that, that it is wrong and it is different to the result in Desktop:
As I have said, this repport was working perfectly, but it was since the last update (quick meausures) that start to be wrong.
Someone has the same problem? It will be really great it someone could help me.
Thanks in advance.
I used to be able to connect to IBM DB2 on z/OS database through Power BI Desktop using ODBC (and unfortunately only with ODBC for unknown reasons). Since the February (I believe) release of Power BI Desktop I now get the following error when trying to connect:
ERROR [HY010] [IBM][CLI Driver] CLI0125E Function sequence error. SQLSTATE=HY010
If I specify a SQL statement then I can connect to whatever table I specify in the SQL statement. But I prefer/need to have the full Navigator functionality that used to work.
What's strange is that using Excel I can connect just fine (with the full Navigator functionality) to that database using the same ODBC driver.
So what's going on with Power BI Desktop and how do I overcome this frustrating obstacle?
I've tried February 2017, March 2017, and April 2017 versions.
I have a problem creating a Power BI report that is connected to SharePoint Online List.
I was able to establish the connection and create the report with Power BI Desktop, but then, I have to modify the SharePoint list, adding some columns to it. The problem is that when I refresh the report, it does not show the new columns (it refreshes the data but not the columns).
Any idea of what is happening?
Thank you in advance,
Experiencing an odd issue using the Custom-Visual "SuperBubbles1.0.1"...
Data from an excel spreadsheet. Column of "Rep Names" all formatted First.Last
For only ONE of the Reps, "Aaron.Miles", the widget does not seem to like the ".Miles" and will not present any visual content when using a slicer to isolate that rep's data.
To add context, in the matrix this rep clearly has data to present and fits the same performance criteria as all the other reps that DO show "bubbles" representing their performance on a customer-level.
I tested making a slight change to the values in the excel data set then refreshing. Here are the steps:
- Adjusted one row item to "Aaron.BURR", which immediately showed visualization once the report was refreshed.
- Adjusted one row item to "Aaron.MilesS" (extra S) and it also immediately showed visualization once the report was refreshed.
Curious if it's the word "Miles" that is causing an issue. Again, this is ONLY occurring in the "Super Bubbles 1.0.1" custom visualization.
Following all the instrucitons to get Cortana hooked in to Power BI Service. One step is to create a report page and set the Type on the Page Size format option to "Cortana". Done. But then after publishing, I see that the page Type setting is now "Custom" and must be reset if I want to have any hope of Cortana finding it.
I'm using the latest Power BI Desktop from April 2017, released March 30 2017 or around then.
This is a bug, in my opinion.
After updating to the last version (April 2017) my jira connection fails with the following error:
Please note that my JIRA credentials are valid and prior to this update I had no issues conecting. Other users are reporting this issue as well.
We have setup a Parent Child Hierarchy with 5 levels in our Multidimensional SSAS cube. When we do a live connection to the cube and pull in the hierarchy with the NamingTemplate defined, we get:
Couldn't load the model schema.
Internal error prevented loading the schema:
An internal error prevented loading the model schema associated with this report.
Please try again later. If the issue persists, contact Power BI support.
Once we remove the names from the Naming Template, Power BI recognizes the hierarchy and assigns generic Names: Level1, Level2, Level3, etc. to the data.
The hieararchy performs just fine in an Excel Pivot Table with the NamingTemplate populated. Any help would be appreciated in getting Power BI to recognize the hierarchy.
Starting at around 4:00 AM CST on 4/21/2017 the automated PBI refreshes from Azure Analysis Services has stopped working. I had to manually refresh all of my reports data sources at 7:20AM CST.
My cube processes every hour, and the PBI datasets are scheduled to automatically refresh every 15 minutes refresh. I have already waited over an hour for the automated refresh to occur, and it has not yet happened.
Please see screenshot below.
Here are the details from "About Power BI"
TimeFri Apr 21 2017 08:39:55 GMT-0500 (Central Daylight Time)
Your data is stored inNorth Central US (Illinois)
I have a pbix file with several queries. I have arranged these queries into groups in the Query Editor, but when I export the pbix file to a template and then open the template, I see that all the groups have disappeared (although all the queries are present). I would like my groups back!
I currently cannot log in to Power BI using my personal account and cannot use any web features. What I want is to be able to go to Power BI in Azure and browse my published dashboards. Charges for hosting should function the same as any other Azure hosted service.
Note: this is not the same as the current Power BI embedded which I can provision in Azure - I am looking for the full web frontend without having to build a separate app for display.
It appears that images do not output in the auto-generated screenshots in the email subscriptions.
Here is the top of the report in the service:
And here is the email subscription of the same report:
Note the image on the left is missing in the screenshot in the email.
This is happening for all of our email subscriptions.
The issue seems to have started on 4/7/2017.
Any idea what's going on?