Consume Excel file stored in M-File from PowerBI
Hello, Is there anyone who has configured PowerBI or a Dataflow in a way to consume an Excel file directly from an M-File Vault? By using the "Get Data" from PowerBI, I'm able to find the file from the M-File desktop version I'm using but then, a local copy of it is getting created in my SharePoint personal folder. Unfortunately in this way, the file used by PowerBI is not any more connected with the real source. I've found on the network the suggestion to work in the opposite way around. Something like: - Store the Excel working file in SharePoint - Link PowerBI to SharePoint (very easy) - Copy the file to M-File when approval is needed ... but I need to secure that my PowerBi is using only the latest approved data from the source. Is there any official best practice on this matter that I can use? Thanks!!!
New powerbi semantic model based out of the lakehouse in the workspace is not getting updated
I created a new powerbi semantic model(not the default model present in the lakehouse) based out of the lakehouse in the workspace but the powerbi semantic model is not getting updated when the changes are made in the lakehouse or the dataflow. For example I added a new column in the dataflow which got updated in the lakehouse but not in the powerbi semantic model which was created in the workspace
Power bi scheduled refresh
I have setup a report with a dynamic dataset and a dataflow. Dataflow consists of a dataset which is refreshed daily and hence required a scheduled refresh. The dynamic dataset requires manually refresh once a year. Now after dataflow being refreshed I can see new data in the table but the visuals don't update. The load and direct refresh settings have already been enabled, still the visuals don't update automatically. Please help, thanks in advance.
Refreshment issues
Hello All, I have one PBI report the data source is data flows for the report , initially in which I have taken just one month of data and created all the visuals After that I have taken full data which is having 5 years of data Case 1: I have taken one month data tables and 5 years of daata tables in the same report and when refrehsing 5 years of data tables, refreshing without any issue Case-2 in report only taken 5 years data tables but removed one month data tables, when refreshing giving error 'Failed to save modifications to the server. Error returned: 'There's not enough memory to complete this operation. Please try again later when there may be more memory available. '. Why in 2nd case it is happening evn though i will be having less data size of report why because i have removed one month data tables I have increased max data usage to 64000, disables auto date/time Disables auto detect relationships also Still facing this erroe Can anyone please help me on this Thanks
Parquet File Loading in Dataflow
Hi I tried loading parquet file from my OneDrive of size 200MB in power bi dataflow but it throw an error of Parquet.Document cannot be used with streamed binary values. It works well with parquet file of smaller size. I am attaching the screenshot with the error. is there any solution for this error?
