Paginated Report couldn't be export trough API
Hi, I have a paginated report connect in direct query to my SQL Server DB and to a Power BI Dataset. In the Power BI interface (website) all works fine. I can view my report and I can export it in all available format but when I want to export it trough the Power BI API, I received this error message : { "title": "Precondition Failed", "status": 412, "detail": "BUSINESS ERROR : Connection Error NotOpen: Connection open intermittent error while reading in Analysis Services, needs retry." } What does it mean ? Why is there a connection to Analysis Services ? Does it related to the Dataset ? FYI : We are using Power BI Premium with embeded capacities. There a lots of other paginated reports in the same workspace (but none with a dataset connection) and it works perfectly (so no rights problem.
How to Change the Date Format in Slicer to DD/MM/YYYY when direct query is used
Hello We have used the Direct Query option (By SQL Query) and used the ABC Table which has the date format as mm/dd/yyyy format in Source Table, Based on this, report has been developed and we could able to change the Date from from mm/dd/yyyy to dd/mm/yyyy in the report but we used the Slicer and added the Date column, it shows in mm/dd/yyyy format. So my Query here is how to change the date format from mm/dd/yyyy to dd/mm/yyyy
Direct Query with Slicer not working
Hi, i developed one dashboard with Direct Query. i created one parameter in power bi (associated with slicer) which i am passing to table valued function in sql server. in my local machine its working fine. but once i am deploying to reporting server. slicer values are not refreshing. you support needed please. Regards,Switch to import mode
I have a problem with the switch from direct Query mode to import mode, I have to qualify fo conditions like "no space" , or "no duplicates" but when I want to delete the duplicates or the spaces in my table it says it can't be done in direct Query mode. So I can't have the conditions to switch to Import mode because I'm the direct Query mode. So I don't know how to do.
Report not showing visuals with error message on Report Server
Hi, we've deployed a report on the Report server which uses mainly SQL queries to get all the data. When opening the file locally it opens fine with no errors. But once on the Report Server most of the visuals don't load and each say that a relationship can't be found (as per images below). Any help will be greatly appreciated. The connection to the data source is correct as other reports use the same one and are running fine.
