I just tried to add some query on Stats-Act-FY2019.
Access facility is a small table with only 112 rows. Yes of course FinanceDB is a substantial original data base.
when I tried to apply changes, it takes too long for Access Facility and keep circling.
Please let me know what should I do?
Kind regards,
Aye
Hi Aye,
If you don't need to preview all of the queries you can turn off Background Data; go to Query Options > Data Load > deselect 'Allow data preview to download in the background'.
You could also try buffering the table. The syntax for Table.Buffer is to simply wrap it around the Source line of code e.g.
Table.Buffer(Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content]),
I would apply it to the fact table query, assuming that is the one that your other queries are referring to and see if that helps.
Mynda
P.S. I moved this post to the Power Query forum.
Thanks, Mynda,
I was in Power BI, edit query and trying to edit query.
I suppose it is not the right way?
Regards,
Aye
Hi Aye,
Power Query is the get and transform data tool in both Excel and Power BI. If your question is regarding a query, then please post it in the Power Query forum. If it is about a Power BI visual then post it in the Power BI forum. If it is about DAX or modelling, then post it in the Power Pivot forum.
Thanks,
Mynda
