RELATED do not work with SQL direct query
Hi together, I have a few databases on sql servers which a get in powerbi via direct query. I created relationships between the datasources and not want to add new columns using the RELATED command. I always get an error that there is no realtionship or the column which i would to take is not availible. But both failures do not exist. The column is there and i choose it from the suggestions which powerbi makes when i search for it and the relationship is also there. I must go via direct query and not import cause the files are too big. It it possible that RELATED do not work with SQL Servers as sources via direct query? Thanks a lot for your help.
Simulate Refresh Button press (Not page Refresh) for direct query report (Report ServeR)
Has anyone found a decent solution to refreshing a direct query report in intervals ? I have been using a 3rd party add-in to refresh the page but would like something to simulate the refresh button press. Then the page (F5) does not refresh but only the report. I dont understand why it is so difficult to find a solution to this. We have a report using direct query to a SQL server displaying on wallboard. The Super Auto refresh add-in works but that refreshes the whole page and then there are a few seconds whre the report is blank due to "Data Refresh" message. If you can just simulate the "Refresh" button, the user experience would be much smoother. Any other solutions out there ?