live connection
15 TopicsCan't export full .pbix + can't publish after live connection workaround
Can't export full .pbix + can't publish after live connection workaround Hi community, I've been running into a frustrating chain of issues over the past few days and wanted to see if anyone else is experiencing the same. Issue 1: Can no longer export .pbix with data I have reports that I've successfully downloaded as .pbix (full copy with data) many times before. Suddenly, I'm getting the error: "We couldn't export to .pbix format." The only download mode that works now is "A copy of the report with a live connection to the data online" — the full data export fails every time. For context: - The report was originally published from Power BI Desktop (not created in the Service) - Large dataset storage format is OFF - No incremental refresh configured - The tables are not large at all, so dataset size shouldn't be a factor - No deployment pipeline involved Issue 2: Can't publish after editing the live connection .pbix After making report edits in Desktop using the live connection file, I tried to publish back to the service and got this error: "An error occurred while attempting to publish 'Report Name.pbix': The remote server returned an error: (404) Not Found." My questions 1. Is anyone else suddenly unable to export full .pbix files from reports they previously could download without issues? 2. Is there a known issue with the UK South region affecting exports and publishing? 3. Any workaround to publish a live connection .pbix back to the service? Thanks in advance, any help or confirmation that others are seeing this would be really useful!475Views0likes2CommentsIs it possible to use ODBC with Live(direct query with delegated user) in PBIRS
Is it possible to use ODBC with Live / DirectQuery using delegated user authentication in PBIRS? Since the ODBC connector supports Kerberos and OAuth, I’d like to know whether Power BI Report Server can leverage these authentication methods when connecting through this type of ODBC connector.Solved1.8KViews0likes5CommentsSSAS Live connection - Current Data
Hello, I am new to the analysis service and I have question about live connection. I am using Power BI SSAS Live connection but every time data is updated in the data warehouse, analysis service needs to be processed (deployed) to load the updated date. as far as I know, analysis service is just a data structure and it is not saving information, thus it must always show actual data without the need to refresh, process or deploying. can someone advise me on how to fix this issue? I want to see live data without SSAS database need to be processed.Solved2KViews0likes3CommentsOn Premise Reports Server Live connection source update
Hi Community, Just want to be clarified regarding live connection source in Reports server. Since I cannot set a refresh schedule for a report with live connection as source, will the report be updated/refreshed automatically.? I've been searching for this but can't seem to find the right answer. Please enlighten me. Thanks.Solved977Views0likes2CommentsPowerBI Server - bypassing the Semantic layer / Live Connection
Hello, We started to use the cloud PowerBI Service to connect to our on-prem based data (Postgres) via the Gateway. However, the problem is that the semantic layer doesn't work well with Postgres and moreover, we actually would like to bypass the Semantic layer and connect to the data natively. Is it even possible using the cloud PowerBI service or the on-prem-based Reporting Server? I couldn't find any place where I can create a Live connection (not DirectQuery). Thank you!Solved655Views0likes1CommentMDX or DAX with using a connection to a power bi dataset
HI,i would like to understand why when i create a report and using report query builder to create simple queries, the query languages that are available are MDX /DAX when it is in import mode ,only mdx when the dataset is in direct query mode. Is there a setting on the pbi tenant ? or it depends on the report builder version? thanks for your time and responses.Solved8.6KViews0likes1CommentField parameters and Live connection availibility
Hi, I've just heard about Field parameters and it seems to be a good new feature. When is it expected to be available in Power BI Desktop for Report Server version? Also, is it possible to use Field parameters with Live connection? Thanks.Solved2.2KViews0likes1CommentPBI SSAS Live Connection multiple models
I just found out that multiple models of SSAS Tabular cannot be connected to one PBIX file. So my question is, should I deploy all the tables in one model or create several models where I will have some of the tables duplicated? Which will give me better performance?954Views0likes2CommentsEmbedding & Filtering Power BI Report Server Live Connection report
Good evening, We have published a report at the on premises Power BI Report Server. We need this report to be embedded to an on premises - as well- web application . The report should interact with the surroundings of the web app in the sense of passing parameters to the report upon users' interactions. The report has been implemented with Live Connection mode (using a tabular model). We test the functionality using a very plain report but report data is not filtered as expected. I would like to mention that a few months ago testing the same capability using a report implemented with Import data mode, we got the expected result. Is filtering through PowerBI Report Server and Live connection reports supported? Thank you in advance.1.8KViews0likes5Comments