Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a fact table containing 600 million records to be used in PBI desktop and I need to build some Analytical reports on this using the Live query mode in Desktop and finally upload it to PBI service on cloud.
Is there a way to restrict data while trying to connect to this fact table because I am not able to see or do anyting because of this huge data and it throws error consistently.
As a source we are using the sql server build on a VM present in Azure Cloud.
Please let us know if there is any solution / workarround to this issue.
Hi @Anonymous,
Based on my research, when you are getting data from sql server, you could edit sql statement to filter the data you want to show:
Regards,
Daniel He
I dont have any requirement to filter dta here as I want to use entire data for Live reporting, users will have the priviledge to filter data based on the dashboard prompts created once the report/dashboard is created and published to Cloud service.
@Anonymous
This is an issue I'm facing currently.
As already been suggested, there is the use of a SQL query to restrict the data.
You could look at using parameters, passed by the end-user using the Power BI Service, that are embedded into the SQL query so the query is processed source side.
Something I am looking at now is the use of a SSAS cube and using Direct Query against that (Source >> SSAS >> Power BI).
I would like to know how others have approached this too as it seems it is common need and if not fulfilled the reporting will be not fit for purpose.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |