datamart

4 Topics

Datamart SQL and SYSDATE
Hi I am looking at developing a datamart and have pulled in tables from Oracle, I want to write a SQL statement for a table using xx_end_date is null or xx_end_date > sysdate This is not working on the datamart SQL. Does anyone have a solution to this? Thanks
Solved
Anonymous
2 years ago Place Report Server
909Views
0likes
2Comments
Datamart started to keep failing the refreshes, details of refresh are blank
Hello, I am using datamart for enterprise wide report which is accessible by couple of thousands of people, and I have there scheduled refresh for every 6 hours. The datamart is used for preloading of data via ODATA protocol from one of the provider's database. Normally, since we started to use this setup almost a month ago, approximatelly 20% of refreshes failed for unknow reason, and it was the reason to establish scheduled refresh 4 times a day, so we can ensure there will be proper refresh at least once a day. Six days ago, we had a line for couple of days where every single refresh was successful, and suddenly for last 3 days, every single refresh fails (even manually started). The reason I am writing this post is, that I am not able to find out what is wrong, as there is no error message available, nor when I download that csv export which should contain details about refresh, this file is completely blank and contains only headers. As to my knowledge, there have been no change in the configuration of providers database, not in the datamart configuration. Any idea what can do, or what steps to take? Any information about what is causing this refresh to fail would be very helpful.
Solved
Draginko
2 years ago Place Report Server
1.5KViews
0likes
2Comments
Visualising SQL queries in datamart - how to update the visualisation once the query's been edited
I've started using the PowerBI Datamart to run SQL queries and visualise the results. I've saved these visualisations as reports. I've since edited the underlying query to add/edit some fields. Now, when I go to edit the visualisations fed by this query, the available data doesn't reflect these changes. Only the old fields from my original query are available. Is it possible to refresh the data behind these visualisations, so I can edit them using the latest data from my SQL query? Thanks for the help!
JeremyCoward
3 years ago Place Report Server
288Views
0likes
0Comments
Azure Analysis Services Connection to Dataflow or Datamart
Hi, So for some reason I cant connect to Analysis Services when I'm connecting via dataflow or datamart. As of now when I'm in the company building I can connect via "Power BI Desktop" to the Analysis Services. Also I published report and use a gateway the team setup for me. The issue I have is I want to create bunch of Dataflow so I can massage the data so user outside the building can still use the data. Specially working from home. Here are the steps I'm doing let me know if im missing anything or I need to talk to our IT team for a privilage setup or something. So I go to the Workspace > New > Dataflow Then I select Then input the credentials When i click next i get this error : What does this mean? I google the error but I dont get any luck finding a solution. Thanks Chris
ChristianDGreat
4 years ago Place Report Server
1.6KViews
0likes
3Comments