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.
