2 Gateways, one Fabric warehouse
Hi Everyone, I have a problem with reports. From what I know, I can only use 1 on-premises gateway in 1 dataset in PBI. Understood. But having MS Fabric, can I pull the data from 2 different gateways to store it in Fabric data warehouse? In this DWH, I already have data from server A, but when trying to access server B, I get such error message: Can you please help me to solve this? From what I know, I need to have different gateways on these 2 servers, right? I need to combine data from server A and B, have relations set in PBI model and allow these reports to refresh automatically. Seems very strange for me that I cannot combine 2 different data sources into data warehouse, since it is one of the principal ideas of DWH - to combine data from different sources. Any ideas? What's important. The credentials I use for accessing this 2nd server via Fabric DataflowGen2 are the same as I use in MSSQL to pull data manually from server. And in MSSQL, it works just fine. Also, when creating PBI dataset that contains data only from this Gateway (server), I can set refresh as well. But I need to combine data from 2 gateways, and here's the problem. Many thanks in advance for any help!
synchronize current time on desktop and fabric
hello, i wanna synchronize current time on desktop and fabric 1. this is my power bi desktop 2. this is my power bi fabric dashboard before auto refresh by schaduler 3. this is my power bi fabric dashboard after auto refresh by schaduler 4. this is my schadule setting 5. this is my refresh history how to syncronize this ?? after i schaduler the data source to current time ???More Granular when pulling Semantic Models from Rest API
I am trying to pull all the tables inside my lakehouse using PowerBI's Rest API. Originally, I used: Reports - Get Reports In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn then created a loop to pull all datasources of reports using the datasetID: Datasets - Get Datasources - REST API (Power BI Power BI REST APIs) | Microsoft Learn However, I notice when it is a semantic model it just shows as a SQL and does not provide the tables. Additionally, It only pulls the sources of reports. I want all the data inside a workspace. Is there a way to the next granular level, so I may see if we are duplicating pulls of tables. Also, is there a way to tell if a table is a shortcut or another re-pull of the same datasource? I am going to test this pull: Admin - WorkspaceInfo GetScanResult - REST API (Power BI Power BI REST APIs) | Microsoft Learn to see if I can get tables.
Connecting to Fabric Warehouse data from a Power BI report running on report server returns an error
When I create the report, everything runs ok in the report builder I connect to the Fabric Warehouse I can run the report from inside the report designer When save to SQL Report server, and try to run the report, I get the following error We couldn't connect to the Analysis Services server. Make sure you've entered the connection string correctly. Request ID xxx Time Service version/powerbi/libs I want to include this in an embedded report, so I can't just publish the report on fabric, since I'm only on F8Publishing Report to Workspace Creates Extra Dataset
I am publishing a report created in Power BI Desktop. The data source is a connection to a Power BI Dataset created via Lakehouse SQL Endpoint. However when I publish that new report, it publishes a new dataset with it. Is it possible to just publish the report since the dataset it is referencing is already published in the service? I now have to update two datasets instead of just one due to this. Here is the flow of how it currently looks: I want to keep the dataset with the green checkmark and remove the one with the red X, while keeping the report working.
